Welcome to this stunning, renovated, turnkey 2-family property offering top-notch modern finishes and income-producing potential, situated on an impressive 50 x 161 lot. Both the first- and second-floor units feature soaring high ceilings, an inviting open-concept layout, and 3 spacious bedrooms and 1 full bathroom each. Enjoy the seamless flow between the formal living and dining areas, leading into stunning modern kitchens appointed with custom cabinetry, elegant quartz countertops, stylish tiled backsplashes, and brand-new stainless steel appliances. The first-floor rear bedroom offers the added convenience of a sliding glass door with direct access to the backyard. Adding even more value, both units feature finished attic and basement spaces in a duplex-style configuration, providing additional flexibility. The finished basement offers a spacious recreation area along with a dedicated laundry room. Major upgrades include updated electrical panels, tankless water heaters, brand-new ductless PTAC heating and cooling systems, along with a new roof, windows, and siding. Enjoy the expansive, fully fenced backyard for outdoor entertaining. Additional highlights include a detached one-car garage and a brand-new extended driveway with parking for multiple vehicles. Conveniently located near public transportation, schools, and shops. Whether you're looking to live in one unit while generating rental income from the other or expand your investment portfolio, you won't want to miss

Listing Tools

Property Details of 1277 E Front Street

Property Details

Interior Features

Exterior Features

Listed by Jonathan Jimenez Cardona of Keller Williams City Views Realty (347-612-2803)

Map Location

 Based on information submitted to GSMLS as of November 14, 2026 11:46 PM EST . All data is deemed reliable but is not guaranteed accurate by the MLS. All information should be independently reviewed and verified for accuracy. IDX information is provided exclusively for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from The Wilton Group. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

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

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

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

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

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

Do not fill in this field:

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

Do not fill in this field:

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

Do not fill in this field:

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

$

Do not fill in this field:

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