Susanlambrechtmi.com Search Results

The Updated Ranch Condo You Have Been Waiting For! This beautiful ground-floor ranch-style condo is situated on one of the premier lots in this highly sought-after condo community, offering serene, wooded views. Enjoy your morning coffee or unwind in the evening on the charming, private patio overlooking the trees—an ideal setting that’s hard to beat. The location is exceptional, with convenient access to shopping, dining, and major expressways. Newer flooring throughout and light neutral colors for that warm, homelike feeling. The interior features a thoughtful layout, with both bedrooms offering their own full bathrooms and spacious walk-in closets—perfect for privacy and comfort. Abundant natural light fills the space through large windows and two expansive door walls off the great room and primary bedroom, each leading to the inviting patio. The kitchen features light maple cabinetry and comes fully equipped with all appliances, including a washer and dryer just off the kitchen area. Additional storage is available with an attached, deep garage that includes built-in shelving and a large, private storage closet, plus ample guest parking. Residents enjoy outstanding community amenities, including a gorgeous pool, clubhouse, fitness center, tennis courts, basketball court, and gazebo. Move-In Ready! This is a must see! You will love it!

2 Beds ⋅ 2 Baths ⋅ 20261080300 MLS

The Updated Ranch Condo You Have Been Waiting For! This beautiful ground-floor ranch-style condo is situated on one of the premier lots in this highly sought-after condo community, offering serene, wooded views. Enjoy your morning coffee or unwind in the evening on the charming, private patio overlooking the trees—an ideal setting that’s hard to beat. The location is exceptional, with convenient access to shopping, dining, and major expressways. Newer flooring throughout and light neutral colors for that warm, homelike feeling. The interior features a thoughtful layout, with both bedrooms offering their own full bathrooms and spacious walk-in closets—perfect for privacy and comfort. Abundant natural light fills the space through large windows and two expansive door walls off the great room and primary bedroom, each leading to the inviting patio. The kitchen features light maple cabinetry and comes fully equipped with all appliances, including a washer and dryer just off the kitchen area. Additional storage is available with an attached, deep garage that includes built-in shelving and a large, private storage closet, plus ample guest parking. Residents enjoy outstanding community amenities, including a gorgeous pool, clubhouse, fitness center, tennis courts, basketball court, and gazebo. Move-In Ready! This is a must see! You will love it!

3491 Tremonte Cir S, Rochester

Courtesy of Real Estate One-Rochester 2486526500

$349,900

Charming Rochester Hills ranch with a private wooded backyard! This inviting home features 3 beds, 2 full baths, abundant natural light, a spacious living room with a stained-glass window, and an updated kitchen with white cabinetry, granite countertops, and a stylish tile backsplash with plenty of storage. The finished lower level provides excellent additional living space for a family room, recreation area, office, or playroom. Outside, enjoy a beautifully landscaped and fenced yard with natural stone patio areas and mature trees creating a peaceful, private setting. Full house generator. Attached garage. Conveniently located in Rochester Hills, within walking distance to Dinosaur Hill Nature Preserve and Paint Creek Trail, this home combines comfortable living, character, and an incredible outdoor retreat. Welcome home! BATVAI.

3 Beds ⋅ 2 Baths ⋅ 20261079773 MLS

Charming Rochester Hills ranch with a private wooded backyard! This inviting home features 3 beds, 2 full baths, abundant natural light, a spacious living room with a stained-glass window, and an updated kitchen with white cabinetry, granite countertops, and a stylish tile backsplash with plenty of storage. The finished lower level provides excellent additional living space for a family room, recreation area, office, or playroom. Outside, enjoy a beautifully landscaped and fenced yard with natural stone patio areas and mature trees creating a peaceful, private setting. Full house generator. Attached garage. Conveniently located in Rochester Hills, within walking distance to Dinosaur Hill Nature Preserve and Paint Creek Trail, this home combines comfortable living, character, and an incredible outdoor retreat. Welcome home! BATVAI.

1330 N Oak St, Rochester

Courtesy of Max Broock, REALTORS®-Birmingham 2486446700

$367,000

* OPEN SUNDAY 10/4 from NOON-2pm * Picture perfect ranch nestled in one of Rochester's most highly sought-after neighborhoods, just moments away from vibrant downtown Rochester. Step inside to a beautifully updated kitchen featuring a custom backsplash, spacious counters and a doorwall leading to the covered patio addition (new in 2022) with sun shades - an inviting space to relax or entertain. Hardwood floors, adding warmth and timeless character to this charming, move-in-ready home. The spacious living room is filled with natural light from the large picture window, while three generously sized bedrooms and a refreshed full bath complete the main level. The finished basement offers plenty of additional living space along with an abundance of storage, adding even more versality to this charming home. The basement comes complete with glass block windows, recessed lighting and water softener. Outside, enjoy a fully fenced backyard with a secluded patio - plus a two car detached garage and an additional storage shed on a cement slab. Furn/AC (2007), Hot water heater (2013), New carpet (2020) in two bedrooms, New roof/house (2022), New windows/sliding door (2022), New gutters & siding/house (2024), bathroom update (2025), New insulated garage door (2020), Painted garage (2024), New entry door/two windows (2021), New Lifetime Clearfield shed on cement pad (2022), Appliances: Refrig (2021), Range/Micro (2023), Washer/Dryer (2025). ALL of this .. AND, Rochester Schools!

3 Beds ⋅ 1 Baths ⋅ 20261078765 MLS

* OPEN SUNDAY 10/4 from NOON-2pm * Picture perfect ranch nestled in one of Rochester's most highly sought-after neighborhoods, just moments away from vibrant downtown Rochester. Step inside to a beautifully updated kitchen featuring a custom backsplash, spacious counters and a doorwall leading to the covered patio addition (new in 2022) with sun shades - an inviting space to relax or entertain. Hardwood floors, adding warmth and timeless character to this charming, move-in-ready home. The spacious living room is filled with natural light from the large picture window, while three generously sized bedrooms and a refreshed full bath complete the main level. The finished basement offers plenty of additional living space along with an abundance of storage, adding even more versality to this charming home. The basement comes complete with glass block windows, recessed lighting and water softener. Outside, enjoy a fully fenced backyard with a secluded patio - plus a two car detached garage and an additional storage shed on a cement slab. Furn/AC (2007), Hot water heater (2013), New carpet (2020) in two bedrooms, New roof/house (2022), New windows/sliding door (2022), New gutters & siding/house (2024), bathroom update (2025), New insulated garage door (2020), Painted garage (2024), New entry door/two windows (2021), New Lifetime Clearfield shed on cement pad (2022), Appliances: Refrig (2021), Range/Micro (2023), Washer/Dryer (2025). ALL of this .. AND, Rochester Schools!

633 Rewold Dr, Rochester

Courtesy of Real Estate One-Troy 2488134900

$1,950

Updated with Luxury Flooring T/O 2BR/2BA end-unit ranch condo on the second story in Rochester's sought-after Boulder Ridge community, just off Dequindre & 24 Mile. 1,338 sq ft of single-level living with vaulted ceilings, fireplace, and brand new A/C and Furnace for energy savings . Updated primary bathroom with sculpture-remodeled bath; heated towel feature in both bathrooms. Kitchen with updated appliances; all appliances included, including in-unit washer/dryer. Great room opens to dining area with deck access. Large foyer, neutral paint, ample closet space. Attached 1.5-car garage with extra storage. Water and association fees included in the rent. Built in 2003. $1950/month, 12-month minimum lease, available now . Pets: allowed , Listing Agent is Related to Seller ,

2 Beds ⋅ 2 Baths ⋅ 20261077027 MLS

Updated with Luxury Flooring T/O 2BR/2BA end-unit ranch condo on the second story in Rochester's sought-after Boulder Ridge community, just off Dequindre & 24 Mile. 1,338 sq ft of single-level living with vaulted ceilings, fireplace, and brand new A/C and Furnace for energy savings . Updated primary bathroom with sculpture-remodeled bath; heated towel feature in both bathrooms. Kitchen with updated appliances; all appliances included, including in-unit washer/dryer. Great room opens to dining area with deck access. Large foyer, neutral paint, ample closet space. Attached 1.5-car garage with extra storage. Water and association fees included in the rent. Built in 2003. $1950/month, 12-month minimum lease, available now . Pets: allowed , Listing Agent is Related to Seller ,

1859 Flagstone Cir, Rochester

Courtesy of Golden Key Realty Group LLC 2484226962

$759,900

Experience the charm of big-city brownstone living in the heart of stylish, quaint Downtown Rochester! This beautiful brownstone condo is less than two years old and is just a short walk from Downtown Rochester's unique boutique shops, exceptional restaurants, and vibrant local attractions. This beautifully designed two-bedroom, two-bathroom executive condo combines contemporary elegance with exceptional craftsmanship, featuring premium materials, designer finishes, and meticulously curated details throughout. The chef's kitchen is a true showpiece, featuring custom Wood Mode inset cabinetry, quartz countertops, a breakfast peninsula and waterfall-edge island with seating, commercial-grade Thermador appliances, and a farmhouse sink complemented by a premium Brizo faucet. The formal dining area flows seamlessly from the kitchen and is bathed in natural light, with a bay of windows and French doors overlooking the beautifully landscaped front courtyard. The primary suite is a true retreat, featuring warm white oak wide-plank flooring, an expansive sleeping area, and two oversized walk-in closets, each thoughtfully appointed with custom organization systems. The spa-inspired primary en suite is appointed with heated natural stone flooring, custom Wood Mode cabinetry, Hansgrohe fixtures, an oversized natural stone walk-in shower with a Brizo water system, and a private water closet featuring a seamless Kohler toilet w/heated seat. A second bedroom and bathroom are equally well-appointed, offering the same level of quality and craftsmanship found in the primary suite. Thoughtfully designed for everyday living, the home also features a spacious laundry room with custom Wood Mode cabinetry, decorative ceramic tile flooring, and an oversized stacked washer and dryer, as well as a functional mudroom with matching tile flooring, a custom built-in bench with generous storage. Additional features include custom commercial blinds, 3 wifi access points & tankless water heater.

2 Beds ⋅ 2 Baths ⋅ 20261067502 MLS

Experience the charm of big-city brownstone living in the heart of stylish, quaint Downtown Rochester! This beautiful brownstone condo is less than two years old and is just a short walk from Downtown Rochester's unique boutique shops, exceptional restaurants, and vibrant local attractions. This beautifully designed two-bedroom, two-bathroom executive condo combines contemporary elegance with exceptional craftsmanship, featuring premium materials, designer finishes, and meticulously curated details throughout. The chef's kitchen is a true showpiece, featuring custom Wood Mode inset cabinetry, quartz countertops, a breakfast peninsula and waterfall-edge island with seating, commercial-grade Thermador appliances, and a farmhouse sink complemented by a premium Brizo faucet. The formal dining area flows seamlessly from the kitchen and is bathed in natural light, with a bay of windows and French doors overlooking the beautifully landscaped front courtyard. The primary suite is a true retreat, featuring warm white oak wide-plank flooring, an expansive sleeping area, and two oversized walk-in closets, each thoughtfully appointed with custom organization systems. The spa-inspired primary en suite is appointed with heated natural stone flooring, custom Wood Mode cabinetry, Hansgrohe fixtures, an oversized natural stone walk-in shower with a Brizo water system, and a private water closet featuring a seamless Kohler toilet w/heated seat. A second bedroom and bathroom are equally well-appointed, offering the same level of quality and craftsmanship found in the primary suite. Thoughtfully designed for everyday living, the home also features a spacious laundry room with custom Wood Mode cabinetry, decorative ceramic tile flooring, and an oversized stacked washer and dryer, as well as a functional mudroom with matching tile flooring, a custom built-in bench with generous storage. Additional features include custom commercial blinds, 3 wifi access points & tankless water heater.

1221 N Main St, Rochester

Courtesy of Keller Williams Paint Creek 2486098000

$2,100

Beautiful condo in the wonderful city of Rochester. Walking distance to Downtown Rochester and near many trails. This is the largest unit in the complex with absolutely the best view! Enjoy your summer evenings on the spacious balcony. 2 Large bedrooms with walk in closets. Freshly painted and carpets were just cleaned for you. Stainless appliances included. 1 car attached garage.

2 Beds ⋅ 2 Baths ⋅ 20261067154 MLS

Beautiful condo in the wonderful city of Rochester. Walking distance to Downtown Rochester and near many trails. This is the largest unit in the complex with absolutely the best view! Enjoy your summer evenings on the spacious balcony. 2 Large bedrooms with walk in closets. Freshly painted and carpets were just cleaned for you. Stainless appliances included. 1 car attached garage.

1905 Flagstone Cir, Rochester

Courtesy of Keller Williams Lakeside 5865320500

$779,900

Enjoy luxury living in Downtown Rochester. Nestled at the top of one of the newest developments in town sits this gorgeous penthouse unit. Enjoy expansive Eastern views of Rochester from all windows and your own, private balcony. This open concept unit is filled with space that has been tastefully thought out. 2 large bedrooms including an en-suite master bedroom and expansive living area flowing into the eat-in kitchen. Large closets and laundry room provide plenty of storage. Included with the unit is a 2 car, fully finished and heated garage with direct access to the building. Note: pictures are digital photos of potentially finished unit. Price listed is for the unit "as-is," but seller is open to finishing to buyer's preference.

2 Beds ⋅ 3 Baths ⋅ 20261060963 MLS

Enjoy luxury living in Downtown Rochester. Nestled at the top of one of the newest developments in town sits this gorgeous penthouse unit. Enjoy expansive Eastern views of Rochester from all windows and your own, private balcony. This open concept unit is filled with space that has been tastefully thought out. 2 large bedrooms including an en-suite master bedroom and expansive living area flowing into the eat-in kitchen. Large closets and laundry room provide plenty of storage. Included with the unit is a 2 car, fully finished and heated garage with direct access to the building. Note: pictures are digital photos of potentially finished unit. Price listed is for the unit "as-is," but seller is open to finishing to buyer's preference.

804 N Main St Unit 3A, Rochester

Courtesy of Aurora Realty Group 5865311982

$439,900

Welcome to 141-143 Ferndale Ave, perfectly situated in a prime location within walking distance of downtown Rochester. This charming, side-by-side ( seperate entrance doors) updated ranch duplex is a fantastic income-generating opportunity through Airbnb. Each renovated unit boasts one bedroom and two full bathrooms, providing ample space and comfort. The property currently generates aprox $3,800 per month in gross income combined from both units. Please note that each unit requires a minimum stay of 27 days, as mandated by the city of Rochester for Airbnb use. The following appliances are included with the property: refrigerators, stoves, and washers and dryers (in each unit).This unique property offers various opportunities, including continuing its successful rental income stream, living in one unit while renting the other, or considering a teardown and rebuild to create a new residential home. Please note that the property is furnished; however, furniture is not included in the sale. With homes in the neighborhood experiencing exceptionally high values, this property is an excellent investment opportunity. Don’t miss out on the potential that 141-143 Ferndale Ave has to offer! Property is non homestead.

4 Baths ⋅ 20261011979 MLS

Welcome to 141-143 Ferndale Ave, perfectly situated in a prime location within walking distance of downtown Rochester. This charming, side-by-side ( seperate entrance doors) updated ranch duplex is a fantastic income-generating opportunity through Airbnb. Each renovated unit boasts one bedroom and two full bathrooms, providing ample space and comfort. The property currently generates aprox $3,800 per month in gross income combined from both units. Please note that each unit requires a minimum stay of 27 days, as mandated by the city of Rochester for Airbnb use. The following appliances are included with the property: refrigerators, stoves, and washers and dryers (in each unit).This unique property offers various opportunities, including continuing its successful rental income stream, living in one unit while renting the other, or considering a teardown and rebuild to create a new residential home. Please note that the property is furnished; however, furniture is not included in the sale. With homes in the neighborhood experiencing exceptionally high values, this property is an excellent investment opportunity. Don’t miss out on the potential that 141-143 Ferndale Ave has to offer! Property is non homestead.

141 Ferndale Ave, Rochester

Courtesy of Brookstone, Realtors LLC 2489630505

$439,900

Welcome to 141-143 Ferndale Ave, perfectly situated in a prime location within walking distance of downtown Rochester. This charming, side-by-side (2 seperate entrance doors) updated ranch duplex is a fantastic income-generating opportunity through Airbnb or monthly income. Each renovated unit boasts one bedroom and two full bathrooms, providing ample space and comfort. Please note that each unit requires a minimum stay of 27 days, as mandated by the city of Rochester for Airbnb use. The following appliances are included with the property: refrigerators, stoves, and washers and dryers (in each unit).This unique property offers various opportunities, including continuing its successful rental income stream, living in one unit while renting the other, or considering a teardown and rebuild to create a new residential home. Please note that the property is furnished; however, furniture is not included in the sale. With homes in the neighborhood experiencing exceptionally high values, this property is an excellent investment opportunity. Don’t miss out on the potential that 141-143 Ferndale Ave has to offer! Property is non homestead.

2 Beds ⋅ 4 Baths ⋅ 20261011970 MLS

Welcome to 141-143 Ferndale Ave, perfectly situated in a prime location within walking distance of downtown Rochester. This charming, side-by-side (2 seperate entrance doors) updated ranch duplex is a fantastic income-generating opportunity through Airbnb or monthly income. Each renovated unit boasts one bedroom and two full bathrooms, providing ample space and comfort. Please note that each unit requires a minimum stay of 27 days, as mandated by the city of Rochester for Airbnb use. The following appliances are included with the property: refrigerators, stoves, and washers and dryers (in each unit).This unique property offers various opportunities, including continuing its successful rental income stream, living in one unit while renting the other, or considering a teardown and rebuild to create a new residential home. Please note that the property is furnished; however, furniture is not included in the sale. With homes in the neighborhood experiencing exceptionally high values, this property is an excellent investment opportunity. Don’t miss out on the potential that 141-143 Ferndale Ave has to offer! Property is non homestead.

141 Ferndale Ave, Rochester

Courtesy of Brookstone, Realtors LLC 2489630505

$1,945,500

CUSTOM, NEW CONSTRUCTION ranch home by luxury builder Bella Homes Inc. Picturesquely set on a cul-de-sac lot next to WestWynd Golf Course in the coveted Heights of Oakland. This open-concept ranch showcases 3 private bedroom suites, a chef’s kitchen with custom cabinetry, walk-in pantry and premium appliances, a stylish wet bar, and a large covered terrace overlooking serene views. Full brick & stone exterior, a 4-car side-entry garage PLUS an optional finished bonus room with full bath above the garage—perfect for guests, studio, or office. Thoughtful details throughout: luxury finishes, architectural ceilings, and indoor-outdoor living. Close to shops, restaurants, parks, and trails. Rochester Community Schools. Under construction—interior photos are of a similar, completed home. Contact Samantha Phillips for specs, selections, and a private tour.

3 Beds ⋅ 4 Baths ⋅ 20251049174 MLS

CUSTOM, NEW CONSTRUCTION ranch home by luxury builder Bella Homes Inc. Picturesquely set on a cul-de-sac lot next to WestWynd Golf Course in the coveted Heights of Oakland. This open-concept ranch showcases 3 private bedroom suites, a chef’s kitchen with custom cabinetry, walk-in pantry and premium appliances, a stylish wet bar, and a large covered terrace overlooking serene views. Full brick & stone exterior, a 4-car side-entry garage PLUS an optional finished bonus room with full bath above the garage—perfect for guests, studio, or office. Thoughtful details throughout: luxury finishes, architectural ceilings, and indoor-outdoor living. Close to shops, restaurants, parks, and trails. Rochester Community Schools. Under construction—interior photos are of a similar, completed home. Contact Samantha Phillips for specs, selections, and a private tour.

2706 Heights View Ct, Rochester

Courtesy of KW Domain 2485900800