info@njqueensrealtybelleville.com

564 Union Ave

Belleville, NJ 07109

9 am to 7 pm

Every Day

Home
Property For Sale
Property For Rent
Commercial Properties
Sell Your Property
Contact Us

Create a Listing

info@njqueensrealtybelleville.com

564 Union Ave

Belleville, NJ 07109

9 am to 7 pm

Every Day

Menu

Home
Property For Sale
Property For Rent
Commercial Properties
Sell Your Property
Contact Us

Privacy Policy
Terms and Conditions
Contact

Account

Create a Listing

Login
Register

Description
Address
Details
Features
Mortgage Calculator
Schedule a Tour
Contact
Reviews
Similar Listings

Home
Ridgewood Village
547 Highland Ave , Ridgewood Village, New Jersey 07450-4729

Share on:
WhatsApp Pinterest Facebook X LinkedIn Email

547 Highland Ave , Ridgewood Village, New Jersey 07450-4729

547 Highland Ave , Ridgewood Village, New Jersey 07450-4729

$3,950,000

0

Property Type
Residential

6
Bedrooms

7
Bathrooms

Share on:
WhatsApp Pinterest Facebook X LinkedIn Email

547 Highland Ave , Ridgewood Village, New Jersey 07450-4729

547 Highland Ave , Ridgewood Village, New Jersey 07450-4729

$3,950,000

Description

Address

Open on Google Maps

City: Ridgewood Village
State/county: Bergen

Details

Updated on December 25, 2025 at 7:29 pm

Property ID HZ4000967
Price $3,950,000
Bedrooms 6
Bathrooms 7
Property Type Residential
Property Status Active

Features

Carbon Monoxide Detector
Dishwasher
Microwave Oven
Range/Oven-Gas
Refrigerator
See Remarks

Mortgage Calculator

Monthly

Down Payment
Loan Amount
Monthly Mortgage Payment
Property Tax
Home Insurance
PMI
Monthly HOA Fees

Total Amount

$

Down Payment

%

Interest Rate

%

Loan Terms (Years)

Property Tax

%

Home Insurance

$

Monthly HOA Fees

$

PMI

%

Schedule a Tour

Tour Type

Date

Time

Your information

Name

Phone

Email

Message

By submitting this form I agree to Terms of Use

Contact Information

View Listings

Queens Realty New Jersey
(973)302-7264(201)725-2828

Enquire About This Property

Name

Phone

Email

I'm a

Message

By submitting this form I agree to Terms of Use

Schedule a tour
Request Info

Queens Realty New Jersey
View Listings

Sat
25
Apr

Sun
26
Apr

Mon
27
Apr

Tue
28
Apr

Wed
29
Apr

Thu
30
Apr

Fri
01
May

Sat
02
May

Sun
03
May

Mon
04
May

Tue
05
May

Wed
06
May

Thu
07
May

Fri
08
May

Sat
09
May

Tour Type

In Person

Video Chat

By submitting this form I agree to Terms of Use

Queens Realty New Jersey
View Listings

By submitting this form I agree to Terms of Use

Call (201)725-2828

Queens Realty New Jersey

Contact me

Queens Realty New Jersey
View Listings

By submitting this form I agree to Terms of Use

Call (201)725-2828

Queens Realty New Jersey
View Listings

By submitting this form I agree to Terms of Use

Call (201)725-2828

Queens Realty is a trusted real estate agency serving Northern New Jersey with over 38 years of experience. We specialize in helping first-time home buyers and are experts in the local markets of Essex, Passaic, and Bergen counties. Whether you're looking to buy your first home, sell a property, or find the perfect rental, Queens Realty is dedicated to providing personalized service to help you achieve your real estate goals.

Contact Us

564 Union Ave Belleville, NJ 07109
info@njqueensrealtybelleville.com

Privacy Policy
Terms and Conditions
Contact

© Houzez - All rights reserved

Compare listings

Compare

Remember me Lost your password?

User registration is disabled for demo purpose.

Forgot Password

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 5400663&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14830
      +items: array:1 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14828
          +post_id: "25025"
          +post_author: 1
          +"ListingKey": "5400663"
          +"ListingId": "4000967"
          +"PropertyType": "Residential"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2025-12-12T09:51:48Z"
          +"RFModificationTimestamp": "2025-12-25T19:29:42Z"
          +"ListPrice": "3950000"
          +"BathroomsTotalInteger": 7.0
          +"BathroomsHalf": "1"
          +"BedroomsTotal": "6"
          +"LotSizeArea": 0.57
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Ridgewood Village"
          +"PostalCode": "07450-4729"
          +"UnparsedAddress": "547 Highland Ave, Ridgewood Village, Bergen 07450-4729"
          +"Coordinates": array:2 [
            0 => -74.14227
            1 => 40.96831
          ]
          +"Latitude": "40.96831"
          +"Longitude": "-74.14227"
          +"YearBuilt": "2025"
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"ListOfficeName": "CHRISTIE'S INT. REAL ESTATE GROUP"
          +"ListAgentMlsId": "255167"
          +"ListOfficeMlsId": "492703"
          +"OriginatingSystemName": "gsmls"
          +"Appliances": "Carbon Monoxide Detector, Dishwasher, Microwave Oven, Range/Oven-Gas, Refrigerator, See Remarks"
          +"ArchitecturalStyle": "Colonial"
          +"AttributionContact": "201-906-0987"
          +"Basement": "Finished, Full, Walkout"
          +"BathroomsFull": "7"
          +"BuildingAreaUnits": "Sqft"
          +"Cooling": "4+ Units"
          +"CreationDate": "2025-12-25T19:29:29.584955+00:00"
          +"Directions": "Lincoln to Highland"
          +"ElementarySchool": "ORCHARD"
          +"ExteriorFeatures": "Deck, Metal Fence, Thermal Windows/Doors"
          +"FireplaceFeatures": "Gas Fireplace, See Remarks"
          +"FireplacesTotal": "2"
          +"Flooring": "Stone, Wood"
          +"GarageSpaces": "3"
          +"Heating": "Multi-Zone"
          +"HighSchool": "RIDGEWOOD"
          +"InteriorFeatures": "CeilCath,SmokeDet,SoakTub,WlkInCls"
          +"InternetAutomatedValuationDisplayYN": false
          +"ListOfficePhone": "201-962-9552"
          +"ListingContractDate": "2025-12-08"
          +"LivingAreaUnits": "Sqft"
          +"LotSizeDimensions": ".569 AC"
          +"LotSizeUnits": "Sqft"
          +"MajorChangeTimestamp": "2025-12-08T22:34:32Z"
          +"MiddleOrJuniorSchool": "WASHINGTON"
          +"MlsStatus": "Active"
          +"OpenParkingSpaces": "6"
          +"OriginalEntryTimestamp": "2025-12-08 22:34:32.0"
          +"Ownership": "Fee Simple"
          +"ParcelNumber": "1151-02805-0000-00006-0000-"
          +"PhotosChangeTimestamp": "2025-12-12T09:51:48Z"
          +"PhotosCount": "45"
          +"Possession": "See Remarks"
          +"Roof": "Asphalt Shingle"
          +"RoomKitchenFeatures": "Breakfast Bar, Center Island"
          +"RoomKitchenLevel": "First"
          +"RoomsTotal": "14"
          +"Sewer": "Public Sewer"
          +"StateOrProvince": "Bergen"
          +"StreetName": "Highland Ave"
          +"StreetNumber": "547"
          +"TaxAnnualAmount": "45000"
          +"TaxAssessedValue": "1307600"
          +"TaxBlock": "2805"
          +"TaxLot": "6"
          +"TaxYear": "2024"
          +"Utilities": "Electric, Gas In Street"
          +"WaterSource": "Public Water"
          +"Township": "Ridgewood Village"
          +"class_name": "RES"
          +"LotSizeAcres": "0.57"
          +"CountyOrParish": "Bergen"
          +"ZipCodeTax": "*"
          +"RoomBed1Level": "First"
          +"RoomBed2Level": "Second"
          +"RoomBed3Level": "Second"
          +"RoomBed4Level": "Second"
          +"RoomDiningLevel": "First"
          +"RoomFamilyLevel": "First"
          +"RoomLivingLevel": "First"
          +"RoomBed1Features": "Fireplace, Sitting Room, Walk-In Closet"
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('5400663')"
          +"ID": "25025"
        }
      ]
      +success: true
      +page_size: 1
      +page_count: 1
      +count: 1
      +after_key: ""
    }
    "RF Response Time" => "0.07 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