Investor Special! In a very desirable area close to Maplewood! Fixer-upper with tremendous upside in a prime, desirable Union location. This property offers a rare opportunity for investors, flippers, or first-time home buyers looking to create their dream home and build instant equity. The home features 3 bedrooms, 3.5 bathrooms, a basement with egress, backyard, and an above-ground pool. Conveniently located near major highways, local amenities, and transportation to NYC, making it ideal for both end users and investors. Perfect for a flip or buy-and-hold strategy. Property is being sold strictly AS-IS. Buyer responsible for all municipal inspections and Certificate of Occupancy (CO). Opportunities like this do not come around often. Will not last. Make your offer today!
Please enter your username or email address. You will receive a link to create a new password via email.
MLS On The Fly Debug Panel
No single property request sent on this page.
MLS On The Fly Debug Panel
array:1 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 5425223&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14950
+items: array:1 [0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14948
+post_id: "34079"
+post_author: 1
+"ListingKey": "5425223"
+"ListingId": "4021550"
+"PropertyType": "Residential"
+"StandardStatus": "Under Contract"
+"ModificationTimestamp": "2026-05-20T14:52:49Z"
+"RFModificationTimestamp": "2026-05-20T20:32:01Z"
+"ListPrice": "499000"
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": "1"
+"BedroomsTotal": "3"
+"LotSizeArea": 0.11
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Union Twp."
+"PostalCode": "07083-4236"
+"UnparsedAddress": "65 Revere Ave, Union Twp., Union 07083-4236"
+"Coordinates": array:2 [0 => -74.270681 => 40.71776]
+"Latitude": "40.71776"
+"Longitude": "-74.27068"
+"YearBuilt": "1930"
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "REALTY ONE GROUP PARAMOUNT"
+"ListAgentMlsId": "406066"
+"ListOfficeMlsId": "5974"
+"OriginatingSystemName": "gsmls"
+"PublicRemarks": "Investor Special! In a very desirable area close to Maplewood! Fixer-upper with tremendous upside in a prime, desirable Union location. This property offers a rare opportunity for investors, flippers, or first-time home buyers looking to create their dream home and build instant equity. The home features 3 bedrooms, 3.5 bathrooms, a basement with egress, backyard, and an above-ground pool. Conveniently located near major highways, local amenities, and transportation to NYC, making it ideal for both end users and investors. Perfect for a flip or buy-and-hold strategy. Property is being sold strictly AS-IS. Buyer responsible for all municipal inspections and Certificate of Occupancy (CO). Opportunities like this do not come around often. Will not last. Make your offer today!"
+"Appliances": "Carbon Monoxide Detector"
+"ArchitecturalStyle": "Colonial"
+"AttributionContact": "201-347-3255"
+"Basement": "Unfinished"
+"BathroomsFull": "3"
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Window A/C(s)"
+"CreationDate": "2026-04-30T19:45:37.166658+00:00"
+"Directions": "65 Revere Avenue, Union, NJ 07083"
+"FireplacesTotal": "0"
+"GarageSpaces": "3"
+"Heating": "Forced Hot Air"
+"HomeWarrantyYN": false
+"InternetAutomatedValuationDisplayYN": false
+"ListOfficePhone": "201-347-3255"
+"ListingContractDate": "2026-04-17"
+"LivingAreaUnits": "Sqft"
+"LotSizeDimensions": "50X100"
+"LotSizeUnits": "Sqft"
+"MajorChangeTimestamp": "2026-05-20T14:52:48Z"
+"MlsStatus": "Under Contract"
+"OpenParkingSpaces": "3"
+"OriginalEntryTimestamp": "2026-04-17 17:17:35.0"
+"Ownership": "Fee Simple"
+"ParcelNumber": "2919-05804-0000-00005-0000-"
+"PhotosChangeTimestamp": "2026-04-17T17:36:51Z"
+"PhotosCount": "1"
+"PoolFeatures": "Above Ground, Outdoor Pool"
+"Possession": "See Remarks"
+"Roof": "Asphalt Shingle"
+"RoomsTotal": "7"
+"Sewer": "Public Sewer"
+"StateOrProvince": "Union"
+"StreetName": "Revere Ave"
+"StreetNumber": "65"
+"TaxAnnualAmount": "7160"
+"TaxAssessedValue": "30700"
+"TaxBlock": "5804"
+"TaxLot": "5"
+"TaxYear": "2025"
+"Utilities": "Electric, Gas-Natural"
+"WaterSource": "Public Water"
+"Township": "Union Twp."
+"class_name": "RES"
+"LotSizeAcres": "0.11"
+"CountyOrParish": "Union"
+"GSMLS_RoomKitchenFeatures": "Eat-In Kitchen"
+"Media": array:1 [0 => array:11 [
"Order" => 0
"MediaKey" => "54252230"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5425223/15e7e196baa489a291b2448462dc0db4.webp"
"ClassName" => null
"MediaSize" => 181354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5425223/thumbnail-15e7e196baa489a291b2448462dc0db4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5425223"
]
]
+"DaysOnMarket": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('5425223')"
+"ID": "34079"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.06 seconds"
]
]
MLS On The Fly Debug Panel
[Warning] Undefined array key "fave_additional_feature_title" in /home/u631305702/domains/njqueensrealtybelleville.com/public_html/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/Integration/Targets/HouzezIntegration.php on line 117
[Deprecated] explode(): Passing null to parameter #2 ($string) of type string is deprecated in /home/u631305702/domains/njqueensrealtybelleville.com/public_html/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/Integration/Targets/HouzezIntegration.php on line 117
[Warning] Undefined array key "fave_additional_feature_value" in /home/u631305702/domains/njqueensrealtybelleville.com/public_html/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/Integration/Targets/HouzezIntegration.php on line 118
[Deprecated] explode(): Passing null to parameter #2 ($string) of type string is deprecated in /home/u631305702/domains/njqueensrealtybelleville.com/public_html/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/Integration/Targets/HouzezIntegration.php on line 118
[Warning] Undefined array key "fave_additional_feature_title" in /home/u631305702/domains/njqueensrealtybelleville.com/public_html/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/Integration/Targets/HouzezIntegration.php on line 117
[Deprecated] explode(): Passing null to parameter #2 ($string) of type string is deprecated in /home/u631305702/domains/njqueensrealtybelleville.com/public_html/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/Integration/Targets/HouzezIntegration.php on line 117
[Warning] Undefined array key "fave_additional_feature_value" in /home/u631305702/domains/njqueensrealtybelleville.com/public_html/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/Integration/Targets/HouzezIntegration.php on line 118
[Deprecated] explode(): Passing null to parameter #2 ($string) of type string is deprecated in /home/u631305702/domains/njqueensrealtybelleville.com/public_html/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/Integration/Targets/HouzezIntegration.php on line 118