Agent profile image in chat bubble
Agent profile image in chat header

Susan Maryanski

Operator | Opulent Living | Keller Williams City Life

Agent profile image in message

I agree to receive automated marketing calls and texts (SMS/MMS) from Opulent Living | Keller Williams City Life, its affiliates and their agents. Msg & data rates may apply. Msg frequency varies. Reply STOP to cancel. Consent is not required for purchase. I also agree to the Terms of Use and Privacy Policy.

main property photo 0
main property photo 1
main property photo 2
main property photo 3
main property photo 4
main property photo 5
main property photo 6
main property photo 7
main property photo 8
main property photo 9
main property photo 10
main property photo 11
main property photo 12
main property photo 13
main property photo 14
main property photo 15
main property photo 16
main property photo 17
main property photo 18
main property photo 19
main property photo 20
main property photo 21
main property photo 22
main property photo 23
main property photo 24
main property photo 25
main property photo 26
main property photo 27
main property photo 28
main property photo 29
main property photo 30
main property photo 31
main property photo 32
main property photo 33
main property photo 34
main property photo 35
main property photo 36
main property photo 37
main property photo 38
main property photo 39
main property photo 40
main property photo 41
main property photo 42
View All (43)
property photo 1
property photo 2
property photo 3
247 Glenwood Ave , Leonia, NJ 07605
$1,288,888
Est. Payment: $6,559.42/mo
5 Bed
3 Bath
0 Sqft
Status: active | Days on site: 34
Get Pre-Qualified
VCR-C15903466 - VCR-C159091383,VCR-C159052275

By providing your number, you are expressly consenting, in writing, to receive telemarketing and other messages, including calls or texts at the number you provided above. This consent is not required to purchase any good or service. Message and data rates may apply. Text STOP to cancel.

This site is protected by reCAPTCHA and the GooglePrivacy Policy and Terms of Service apply.

Agent profile image
Susan Maryanski
Operator
View agent profile
Email
Call

House Description

Stunning, move-in-ready, and fully renovated pacious 5-bedroom, 3 full bathroom home in the heart of one of Leonia’s most desirable locations. Thoughtfully updated and meticulously maintained, this move-in-ready home offers a versatile layout ideal for modern living. The 1st floor features an expansive living and dining room that flow seamlessly into the stunning Porcelanosa kitchen, designed with both style and function in mind and showcases high-end finishes and sleek European design. This level also includes 2 huge bedrooms, a full bathroom, and a home office. The 2nd level offers a loft-style bonus living area perfect for a home office, playroom, or additional lounge, 3 additional spacious bedrooms, a full bathroom, and a finished attic/den space. The fully finished basement adds great value with a large rec area, custom wet bar, a 3rd full bathroom, and access to the oversized 2 car tandem garage. Throughout the home, you will find gleaming hardwood floors, new European-style solid interior doors, excellent closet space, and premium finishes. Many recent renovations included central air (2023), commercial boiler (2021), pavers (2023) and more. Beautifully landscaped front and backyard spaces, including a large storage shed, offers both curb appeal and stylish outdoor living. Turnkey home with nothing to do but move right in. Rare opportunity to own a fully renovated residence in a prime Leonia location, so close to NYC, amazing school system, and wonderful community
Show more

Highlights

Listed by Taylor Lucyk , 201-360-1292 The Agency One Rock-Paramus , 201-975-4141. New Jersey Multiple Listing Service mls logo

Property Type

Residential

County

Bergen

Area

Leonia

Listing ID

26022727

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:5
  • ▪ Bathrooms:3
  • ▪ Full Bathrooms:3
Air Cond:Central Air
Fireplaces:
Basement:Finished,Full
Other:11,Deck / Patio,Hdwd As In,Skylights

Exterior Features

Lot:Regular
Parking Features:Attached,Tandem
Principal Interest
$6,559
Taxes
$1,563

Home Price

$1,288,888

Loan Details

30 yrs
6.562%

Down Payment

20%
$257,778
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$6,559.42

Principal

Taxes

Principal Taxes HOA Total
Monthly $6,559.42 $1,563.25 $0.00 $8,122.67
Yearly $78,713.02 $18,759.00 $0.00 $97,472.02
Total $2,361,390.73 $562,770.00 $0.00 $2,924,160.73

Today's Rates

30 Year

6.56%

20 Year

6.5%

15 Year

6%

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Jul 2026

Average Price

All Price Ranges
N/A
Jul 2026

Average Days on Market

All Price Ranges
N/A
Jul 2026
Market insight data is pulled from the same city as the listing being viewed (Leonia, NJ).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

(c) 2026 New Jersey Multiple Listing Service, Inc, All Rights Reserved. Information provided by the New Jersey Multiple Listing Service, and Information Deemed Reliable But Not Guaranteed. The listing content relating to real estate for sale on this web site comes in part from the Internet Data Exchange program of the NJMLS, Real Estate listings held by brokerage firms other than the brokerage firm of this website are marked with the Internet Data Exchange logo and detailed information about them includes the name of the listing brokers. The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Data last updated: 2026-07-21T22:02:17.700Z

© 2026 New Jersey Multiple Listing Service

MLS Logo - New Jersey Multiple Listing Service