Welcome to 823 Bishop Street in Union! This 3-bedroom, 2-bath Colonial offers approximately 1,344 square feet of living space with a traditional layout featuring a living room, dining room, kitchen, and three bedrooms. The property is being offered AS-IS and requires updating and repairs, presenting an excellent opportunity for a buyer looking to personalize the home. Additional space is available in the finished basement and unfinished attic for storage. Conveniently located near shopping, dining, schools, major highways, and public transportation. Bring your vision and transform this property into your dream home! Sale is subject to sellers securing suitable housing.
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 5458747&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#15359
+items: array:1 [0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15357
+post_id: "48230"
+post_author: 1
+"ListingKey": "5458747"
+"ListingId": "4050919"
+"PropertyType": "Residential"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-09-08T11:36:41Z"
+"RFModificationTimestamp": "2026-09-08T15:49:23Z"
+"ListPrice": "499999"
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": "0"
+"BedroomsTotal": "3"
+"LotSizeArea": 0.09
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Union Twp."
+"PostalCode": "07083-7101"
+"UnparsedAddress": "823 Bishop St, Union Twp., NJ 07083-7101"
+"Coordinates": array:2 [0 => -74.231321 => 40.67343]
+"Latitude": "40.67343"
+"Longitude": "-74.23132"
+"YearBuilt": "1940"
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "GOLD STANDARD REALTY"
+"ListAgentMlsId": "306621"
+"ListOfficeMlsId": "4247"
+"OriginatingSystemName": "gsmls"
+"PublicRemarks": "Welcome to 823 Bishop Street in Union! This 3-bedroom, 2-bath Colonial offers approximately 1,344 square feet of living space with a traditional layout featuring a living room, dining room, kitchen, and three bedrooms. The property is being offered AS-IS and requires updating and repairs, presenting an excellent opportunity for a buyer looking to personalize the home. Additional space is available in the finished basement and unfinished attic for storage. Conveniently located near shopping, dining, schools, major highways, and public transportation. Bring your vision and transform this property into your dream home! Sale is subject to sellers securing suitable housing."
+"Appliances": "Range/Oven-Gas, Refrigerator"
+"ArchitecturalStyle": "Colonial"
+"AttributionContact": "908-344-3518"
+"Basement": "Finished"
+"BathroomsFull": "2"
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Window A/C(s)"
+"CreationDate": "2026-09-08T13:25:35.925481+00:00"
+"Directions": "See GPS"
+"FireplacesTotal": "0"
+"Flooring": "Wood"
+"GarageSpaces": "1"
+"Heating": "Radiators - Hot Water"
+"InternetAutomatedValuationDisplayYN": true
+"InternetEntireListingDisplayYN": true
+"ListOfficePhone": "908-344-3518"
+"ListingContractDate": "2026-09-07"
+"LivingAreaUnits": "Sqft"
+"LotSizeDimensions": "40X100"
+"LotSizeUnits": "Acres"
+"MajorChangeTimestamp": "2026-09-07T20:44:22Z"
+"MlsStatus": "Active"
+"OriginalEntryTimestamp": "2026-09-07 20:44:23.0"
+"Ownership": "Fee Simple"
+"ParcelNumber": "2919-00201-0000-00009-0000-"
+"PhotosChangeTimestamp": "2026-09-08T11:36:41Z"
+"PhotosCount": "3"
+"Possession": "See Remarks"
+"Roof": "Asphalt Shingle"
+"RoomsTotal": "6"
+"Sewer": "Public Sewer"
+"StateOrProvince": "NJ"
+"StreetName": "Bishop St"
+"StreetNumber": "823"
+"TaxAnnualAmount": "9142"
+"TaxAssessedValue": "39200"
+"TaxBlock": "201"
+"TaxLot": "9"
+"TaxYear": "2025"
+"Utilities": "Gas-Natural"
+"WaterSource": "Public Water"
+"Township": "Union Twp."
+"class_name": "RES"
+"LotSizeAcres": "0.09"
+"CountyOrParish": "Union"
+"GSMLS_RoomBed1Level": "Second"
+"GSMLS_RoomBed2Level": "Second"
+"GSMLS_RoomBed3Level": "Second"
+"GSMLS_RoomDiningLevel": "First"
+"GSMLS_RoomLivingLevel": "First"
+"GSMLS_RoomKitchenLevel": "First"
+"GSMLS_RoomDiningFeatures": "Formal Dining Room"
+"GSMLS_RoomKitchenFeatures": "Breakfast Bar"
+"Media": array:3 [0 => array:11 [
"Order" => 0
"MediaKey" => "54587470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5458747/56459a9b77c52f737b54c6ea2835d732.webp"
"ClassName" => null
"MediaSize" => 101156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5458747/thumbnail-56459a9b77c52f737b54c6ea2835d732.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5458747"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "54587471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5458747/9ab9894cb2667fd96b86d129ce76d0ea.webp"
"ClassName" => null
"MediaSize" => 104496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5458747/thumbnail-9ab9894cb2667fd96b86d129ce76d0ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5458747"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "54587472"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5458747/d5df2e3f09f105ac000e488cd69a3bc5.webp"
"ClassName" => null
"MediaSize" => 124498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5458747/thumbnail-d5df2e3f09f105ac000e488cd69a3bc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5458747"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('5458747')"
+"ID": "48230"
}
]
+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