A golf-deeded villa on Sorrento Way with these fantastic views rarely becomes available. Take in the spectacular sweeping view of the expansive 11th fairway and large pond bordered by lush landscaping while you relax on your newly extended and appointed lanai- ** a $90K** new upgrade along with the new landscaping design. The spacious lanai is complete with a new summer kitchen and bar, built-in Sedona premium gas grill, beautiful weatherproof HDPE cabinetry and granite countertops, this is where good times begin. A remote-operated retractable awning and panoramic screening showcase the amazing, brilliant sunsets. This beautiful single-family home in Esplanade Golf and Country Club is tastefully upgraded with an additional **$96K ** in interior design elements, and meticulously maintained. Offerings include two bedrooms, two baths, a den with sliding pocket doors, a spacious kitchen and great room, dining room and a deeded golf membership.  The spacious bedrooms each will accommodate a king-size bed and boast walk-in closets. Designer accents include tray ceilings in the great room, dining area, den and primary bedroom, 8-foot doors throughout, extensive crown molding and 5½-inch baseboards, as well as beautiful porcelain plank-style flooring throughout the living areas. Highlights of the large kitchen include the Cali-style extended kitchen counter, quartz countertops, upgraded level 5 cabinetry and SS appliances, and glass subway tile backsplash, all of which contribute to the rich appeal of this popular, well-designed Roma floor plan. The two-car garage with 4-foot extension adds practicality and additional storage. Filled with natural light, the great room with triple-panel sliding stackable doors opens to the ultimate outdoor space for entertaining and enjoying the Florida lifestyle. The new, professionally installed landscaping with extensive outdoor accent lighting is magical. Esplanade offers resort-style living with so many options to enhance the living experience of all residents. Two large resort-style pools, two clubhouses with fitness centers, meeting rooms for clubs, spa, salon, rooms for yoga and other classes, as well as pickleball, tennis, bocce ball and more. The Culinary Center offers fine dining and casual lunches- a place to hang out, the Bahama Bar is the go-to for light bites and camaraderie. Community events, live music, and educational presentations are for all to enjoy and are arranged by a lifestyle director. The HOA dues include golf membership, landscape care and maintenance, and irrigation water. Lakewood Ranch is ranked as one of the best-selling planned communities in the nation.

Mary Ann Hartmann

PREMIER SOTHEBYS INTL REALTY

Located on the southern shores of the Manatee River in Tidewater Preserve, this pristine conditioned three-bedroom, two-bath, two-car garage home is centered on a preserve overlooking a grassy field flanked by a majestic live oak tree. The split floor plan features a primary suite on one side of the house with two additional bedrooms and another full bath on the other side of the house. The home is ideal for entertaining with a formal dining room that flows effortlessly into the great room and kitchen. The home has natural hickory hardwood flooring throughout and also includes an oversized den/office, a separate kitchen nook, a laundry room, and an oversized screened-in lanai. The primary suite includes his and her walk-in closets with custom built-in drawers and shelving; his and her vanities; as well as a separate soaking tub and walk-in shower. The kitchen includes brand new stainless steel appliances, Kinetico K5 reverse osmosis drinking water station, granite countertops, under cabinet lighting, custom tile back-splash, and 42 inch cabinets with soft close/roll-out lower cabinet shelving. The great room features sliding glass doors, volume ceilings and a custom built-in entertainment unit with seating, storage and quartz countertops. The expansive, northeasterly-facing screened-in back lanai has brick pavers and is a perfect space for indulging yourself with sun-filled afternoons or dining under a blanket of stars. Additional upgrades include a Kinetico whole house water softener/filtration system, four-foot bronze aluminum fenced in backyard, custom landscaping with white river rock, landscape night lighting, heavy duty overhead storage racks in the garage, custom lighting, custom window coverings and minkaAire ceiling fan fixtures. Tidewater Preserve is a 24/7 security guard gated, landscape maintenance-free boating community that includes free internet/cable TV, a private marina, clubhouse, three swimming pools, three tennis courts, fitness center, dog park and kids playground. This home is a must see, call today to schedule a showing!

Matt Buttner

LIST NOW REALTY, LLC

Introducing this Florida ranch-style home nestled on an expansive shaded lot, complete with a captivating kidney-shaped pool and spa. Located in one of the highly sought-after IMG Academy adjacent neighborhoods, this residence offers the perfect blend of luxury and tranquility. Surrounded by the lush greenery of a semi-private golf course, the community provides a serene, sun-filled living experience. As you enter the property, you'll be greeted by a graceful circular driveway designed to effortlessly accommodate both automobiles and golf carts. Step inside to discover an inviting living space adorned with a well-equipped and visually appealing kitchen. The kitchen boasts a convenient island for easy food preparation and guest seating, perfect for culinary enthusiasts. The adjacent living room features a charming woodburning stone fireplace, creating a cozy ambiance for relaxing evenings. Elegant double bay windows adorn the dining area, seamlessly connecting the various living areas for comfortable everyday living and entertaining. For those seeking a seamless indoor-outdoor lifestyle, the kitchen opens up to a spacious lanai with wall-to-wall sliders. This allows for views of the new heated, saltwater pool and paver patio, as well as the expanses of the fenced in backyard. Each of the generously sized bedrooms offers access to an en suite bathroom with glass-enclosed showers. These bedrooms can easily accommodate additional seating or a personalized dressing area. This home is truly worth seeing and acquiring for your own. Well situated to take a short drive to either St Petersburg, Sarasota, or Longboat Key beaches. Don't miss out on this incredible opportunity to own a home in sought after, El Conquistador neighborhood.

Clare Merrick

SMITH & ASSOCIATES REAL ESTATE

NEW PRICE!! Welcome to this St. Armand award-winning model built by Ashton Woods! Located on a prime water-view home site. In every corner of this luxury open floor plan modern home, meticulous attention to detail and a commitment to exceptional craftsmanship are evident. From its architectural grandeur to its interior sophistication, this residence not only embodies the pinnacle of contemporary design but also offers a lifestyle that is both opulent and inviting—a true sanctuary that one could easily imagine gracing the pages of the most esteemed design magazines. The foyer, with its soaring ceiling and a modern chandelier that resembles a cascade of crystal droplets, sets the tone for what lies ahead. The porcelain plank tile floors guide you towards the expansive living area with crown molding and tray ceilings, then flow seamlessly to the gourmet kitchen, a culinary enthusiast's dream, adorned with a large center island with granite countertops, designer stainless steel appliances, tile backsplash and dry bar - ideal for entertaining. The master suite beckons with lots of natural light framing views of the verdant pond and landscape. The in-suite bathroom is a spa-like oasis, complete with a large walk-in shower with a rain shower head enclosed in seamless glass, dual sinks, and an upgraded closet with built-in cabinetry, jewelry drawer and abundant storage. Additional 3 bedrooms, each a testament to bespoke design and comfort, offer serene retreats for family and guests alike. Custom-built closets, and upgraded ceiling fans, 2 of bedrooms share a Jack & Jill bath, integrated smart home technology. Step outside through the triple sliding packet doors into an alfresco paradise under a covered lanai with a water view. This lot has plenty of space to build and design your own pool. Rosedale Golf & Country Club an award-winning community featuring a full-service restaurant inside an expansive clubhouse, finely manicured 18-hole golf course, Har-Tru/clay tennis courts, and Fitness Center next to a Junior-Olympic sized pool for getting in your laps or just relaxing after a strenuous workout. Close to UTC Mall, Restaurants, Groceries, A-rated schools, a quaint downtown and Main Street, Sarasota Int’l Airport, and famous beaches. HOA includes exterior yard maintenance, cable & internet, and 24-hour gated security. NO CDD!

Silvia Chiaro

COLDWELL BANKER REALTY

Welcome to your Bermuda-style oasis, where sophistication meets picturesque waterview. This gently used,1.6 year old home, impeccably built, with four-bedrooms, 2.5-bathrooms offers breathtaking water view from the living area & pool, as well as an array of amenities that cater to your every desire. As you step inside, you're greeted by an elegant foyer with privacy glass front door. The home boasts hurricane-rated windows & sliders, ensuring peace of mind. Crown molding & wood flooring throughout exude a timeless elegance, while the trey ceilings add a touch of grandeur. The gourmet kitchen is a chef's dream, featuring high-end quartz countertops & island, a top-of-the-line cooktop & oven, & upper cabinets that reach the ceiling, complete with crown molding. Thoughtful details like roll-out cabinet storage, a corner cabinet, & a trash drawer enhance functionality. A dry bar & custom closets throughout the home offer ample storage & convenience. The master suite is a sanctuary, with separate his-and-hers custom closets & a master bathroom that rivals a spa. Enjoy Italian tile double showers  & comfort-height toilets. This home is wired for modern living, with low voltage wiring for exterior security cameras, under counter lighting, a wireless modem, & wireless speakers in the family room, dining room, master bedroom & bathroom. Additional features include a tankless water heater, electrical receptors for all TVs , a laundry sink, an epoxy-coated garage floor, &  a hurricane-rated, belt-driven garage door with battery backup. Step outside the wall of sliders to your private paradise. The saltwater pool features a 6-inch raised wall with waterfalls, a large hot tub with spill-over, & dual pumps for faster heating. Enjoy the ambiance of LED-color lights, a remote controller multi-function Pent-Air controller, sun shelf with a sprayer, and oversized entry steps with a Pebble Tec finish. The lanai & paver-surrounded pool area, driveway & sidewalk provide a seamless indoor-outdoor living experience. Entertain effortlessly with the covered outdoor area, equipped with speakers, lights, outlet, fan hookups, as well as a gas outdoor kitchen hook-up. This exquisite home epitomizes: luxury, convenience, & relaxed living at its finest. Schedule your private tour today & experience the unparalleled lifestyle this property offers. $200,000 of upgrades at the design center to this modern designed home. Convenient to local & highway travel, a multitude of stores & restaurants, coming soon a new Watercolor Community Clubhouse with pool, gym & meeting areas. Why wait when you can move in now?

Stephanie Churchill

REALTY ONE GROUP SUNSHINE

Investment Opportunity in Cortez, FL - Potential Redevelopment Project (RDD-6 Zoning/Residential Duplex, 6 Units/Acre). Discover the potential of this hidden gem in Cortez, FL - an ideal redevelopment project that spans .82 acres of land, offering a unique investment opportunity. Located just 2 miles from the pristine beaches and a block from the picturesque Sarasota Bay, this property promises a blend of tranquility and convenience.  Proximity to the Beach and Sarasota Bay Imagine the luxury of having the beach just a short 2-mile drive away and the captivating Sarasota Bay within walking distance. This prime location not only ensures a serene environment but also guarantees a high demand for both short-term and long-term rentals. Property Highlights: •Land Area: .82 acres •Location: Cortez, FL •Distance to Beach: 2 miles •Proximity: 1 block from Sarasota Bay Short-Term Rental Opportunities: Benefit from the flexibility of short-term rentals, tapping into the thriving vacation market. With the allure of nearby beaches and the bay, this property is perfectly positioned to attract vacationers seeking a coastal escape. Endless Possibilities: •Residential Development: Craft a residential haven amidst the natural beauty of Cortez. •Vacation Rentals: Cater to the burgeoning vacation rental market with stunning short-term accommodation. Seize the opportunity to redefine coastal living in Cortez, FL. For inquiries and to unlock the full potential of this property, contact us today. Don't miss out on being a part of this exciting redevelopment journey!

Matt Guthrie

MATTHEW GUTHRIE AND ASSOCIATES REALTY LLC

Country paradise in town!  Custom-built family residence situated on 2.5 acres located west of I-75 with no HOA or CDD!  Huge detached workshop/garage perfect for car collectors or hobbyists.  Roof replaced in 2022 and A/C replaced in August 2024.  Inviting two story design with cedar siding and ceiling beams, two stone fireplaces and enormous front and back porches to relax and enjoy the peaceful setting.  Mature oak trees frame the property and provide a natural canopy of shade.  Spacious kitchen in the center of the home opens to both the living and dining rooms creating an easy flowing floor plan with plenty of room for family gatherings. Bedrooms are all good size, and most open out to a screened in deck with serene treetop views. Rustic charm and character abound with wood and stone accents, built in window seats, a laundry chute, and even a quirky old-fashioned phone booth! Grand foyer entry. Attached two car garage AND giant detached workshop with an RV hookup on site too.  Bring all your toys! Huge utility room plus storage area.  Ideal work from home setup.  This is a RARE OPPORTUNITY.  Come and enjoy the luxury of peaceful privacy with acreage in close proximity to shopping, dining and easy access to I-75. This is more than just a home - it's a lifestyle.

Cheri Ivarsson

BERKSHIRE HATHAWAY HOMESERVICES FLORIDA REALTY

Welcome to this charming patio home located in the renowned Lakewood Ranch community. This residence boasts a comfortable and thoughtfully designed floor plan, perfect for both relaxation and entertaining. The interior features a spacious bonus room, ideal for a home office or media center. The kitchen is a chef's dream, equipped with sleek stainless steel appliances and ample counter space. The home also offers a well-appointed master suite, providing a serene retreat after a long day. Enjoy the convenience and luxury of living in a master-planned golf community, known for its exceptional amenities. Lakewood Ranch has been recognized as the #1 community for seven consecutive years, presenting a range of recreational options including tennis courts and a fine dining restaurant. This gated community ensures privacy and security, making it an ideal choice for your next home. Don't miss the opportunity to experience all that this remarkable home and community have to provide!

Sandra Osorio, PA

COMPASS FLORIDA LLC

Welcome to your dream home in the desirable community of Country Meadows! This stunning Barbados model by Medallion Homes boasts a spacious garage that will surely make you smile. Tucked away as a side load, it maintains the curb appeal without dominating the view from the road.  With over an one acre to work with , the sellers had the home set back an extra 30 feet deep to take advantage of the large and deep homesite.    Prepare to be impressed by the garage's features, including a built-in car lift, high ceilings, and room for up to four large vehicles, with potential for 6 cars to fit.   The garage has 1,664 sqft (52X32), plenty of space.  Convenience meets luxury with the inclusion of an air-conditioned half bathroom and storage room, perfect for climate-controlled storage or quick pit stops during projects.  Step inside to discover a thoughtfully designed layout featuring 4 bedrooms, 3 and a half bathrooms, and a separate den, ensuring ample space for everyone. The master suite offers a tranquil retreat with sliders leading to the pool area, a spacious walk-in closet, and a luxurious bathroom complete with dual sinks, a garden tub, and a shower.  The open-concept design seamlessly connects the family room and kitchen nook, with sliders opening onto the screened lanai, ideal for indoor-outdoor living and entertaining. Owners added some custom features including seamless gutters, whole house central vacuum, and added extra insulation for the interior walls for extra sound dampening.  Outside, the inviting pool sets the stage for gatherings with friends and family.  Situated on over an acre, this home offers ample privacy, with generous spacing between homes and a lush preserve area at the rear of the property. Country Meadows is known for its spacious homesites, all boasting tile roofs and brick paver driveways.  With low HOA fees and no CDD fees, you can enjoy the Florida lifestyle without breaking the bank. Conveniently located near shopping, excellent schools, and a nearby boat ramp, this home offers the perfect blend of luxury and convenience.  Don't miss the opportunity to experience this home for yourself. Take a virtual tour and schedule your visit today!

Joe Murphy

Under Construction. Lorraine Lakes is a serene and beautiful neighborhood within the acclaimed Lakewood Ranch master-planned community, offering resort-style living and a wide variety of amenities. This community offers a variety of popular amenities, such as an aerobics studio basketball court, clubhouse, fitness center, playground and so much more. The open floorplan shared between the Great Room, kitchen and dining room serves as the heart of this single-level home, while sliding glass doors lead to a lanai for effortless indoor-outdoor living and entertaining. A versatile den is ideal for a home office or study space, and four bedrooms offer enough space for the whole family. Prices and features may vary and are subject to change. Photos are for illustrative purposes only. Estimated delivery date is Early 2025.

David Meyers

LENNAR REALTY INC

Welcome to your dream home in Country Club East community! This beautifully updated 3-bedroom, 2.5-bath pool home offers a blend of modern elegance and comfortable living. Enjoy an open-concept living area with abundant natural light, perfect for entertaining or relaxing with family. The home has been tastefully updated with high-quality finishes, including sleek flooring, contemporary fixtures, and a fresh, neutral color palette. The modern kitchen boasts stainless steel appliances, granite countertops, and ample cabinetry, making meal preparation a delight. Both bedrooms are generously sized ensuring privacy and comfort. The master suite includes a walk-in closet and a beautifully designed bathroom with dual vanities. Step outside to your private oasis—a sparkling pool surrounded by a spacious deck and lush landscaping, perfect for relaxing or hosting gatherings. The home also includes a convenient half-bath for guests, a two-car garage, and access to the community’s top-notch amenities, including golf courses, tennis courts, and walking trails. Located in the highly sought-after Country Club East, you’ll enjoy a serene setting with easy access to local shops, dining, and recreational facilities. Don’t miss this opportunity to make this exquisite property your new home!

Cori Yax

NEXTHOME DREAMS

Frederick Flis

REAL ESTATE MART

This home is located in one of the best locations in Northwest Bradenton. Minutes to the sugar sand beaches of the Gulf of Mexico, Robinson Preserve with hiking and kayak water trails, and the DeSoto National Park on the banks of the Manatee River. The community common area features 450 feet of trec boat dock, clubhouse, pool, spa, with tennis and pickle ball courts.  Overlooking the Tampa Bay and don't forget the fabulous sunsets.  The home features a contemporary design with high ceilings throughout.  Solid counter top with a spacious eat in counter.  Gas cook top and double oven for the chef in your home.  Premium kitchen wood cabinets.  Separate wet bar with gas burning fireplace.  The master suite has a walk-in closet with washer/dryer.  Separate steeple tub, shower and water closet. Split bedroom design with second bedroom having a full bath and sliding doors to the garden porch area.  Also an over-sized two car garage with side door access.  This home features beautiful landscape throughout the backyard from the covered porch area. Great for entertaining and having cookouts.

John Rehmann

Glamorously full of perfect upgrades, this Water View home is versatile for many living and spatial needs. Located in the tranquil gated community of Silverlake. This spacious 4BR, 2.5 BA home offers 2408 SqFt. The Master suite is conveniently located downstairs for extra privacy while the remaining 3 bedrooms are upstairs. The entire house was completely remodeled and upgraded. Frameless shower enclosure in master bathroom with acrylic soaking bathtub. Smart Toilet and Dual Vanity. Gourmet Kitchen embellished with Cooktop, Range Hood Vented to outside, Combination Microwave/Thermal Dual Wall Oven, Quartz Countertops, Acrylic and wood cabinets, Porcelain Tile Backsplash, Italian luxury Porcelain Tile Floors throughout, marble stairs, Upgraded Light Fixtures and Fans, Upgraded Baseboards, All glass Interior Doors, Motorized Shades over Sliding Glass Doors. Paved Lanai offering lake views with breathtaking sunsets and Covered Screen-Enclosed. Enjoy the benefits of low HOA fees and no CDD charges. Positioned conveniently close to schools, shopping centers, and dining establishments, with the University Town Center just minutes away—a premier locale for shopping, dining, and exploration. Sarasota airport is within proximity, and the finest beaches are just a short drive away. Allow us to arrange a viewing of your dream abode—schedule your appointment today! Don't miss out on this beautiful home.

Zamira Fernandez-Perez

RE/MAX BAYSIDE REALTY LLC

Lisa Taylor

FINE PROPERTIES

Bring your BOAT! Welcome Home to the Best Value in Tidewater Preserve! On the banks of the Manatee River sits this unique and highly desirable community with BOATING access to the Gulf of Mexico! This meticulously maintained floor plan features 4 Bedrooms plus an Office/Den. When you arrive you'll notice a separate entrance that could be a possible IN-LAW/TEENAGER SUITE! You're greeted with an impressive Foyer and 10 ft ceilings throughout on this private lot with only one neighbor. The Great Room/Dining/Kitchen combo creates a large open floor-plan and makes for a perfect entertaining space. Need some more room? Just open up your pocket sliders to the spacious Lanai with a beautiful and private preserve view. The Kitchen features a large island, granite countertops, and stainless steel appliances (new Refrigerator and Range). The large Master retreat has dual walk-in closets, dual sinks, a shower, and garden tub. A private En-Suite is on the garage side of the home. The opposite side could become an in-law suite with it's own private entrance and full bath. Out back there's space to add your dream Pool or you can always make the quick walk next door to the Lagoon Pool! Tidewater Preserve is a 24/7 staffed Gated Community with three Pools, two Gyms, Lodge, Marina, Riverfront Nature Trail, Kayak Launch, Playground, Har-Tru Tennis Courts, and a Full Time Lifestyle Coordinator with a full event calendar. The HOA includes all Lawn Maintenance, Resort Style Amenities, and Cable/Internet package (500mbps). Boat Slips are currently available in the Marina. Take a Boat Ride to our world class Sandbars and waterfront Restaurants- living in Tidewater opens up tons of possibilities to enjoy our Coast and truly live life on the water. Conveniently located near downtown Bradenton, Lakewood Ranch, UTC Mall, Sarasota, and our beautiful Gulf Beaches. 3D tour available.

Josh Mills

Experience the epitome of the Florida lifestyle in this one of a kind home. This stunning 4 bedroom/2.5 bath/den property, sprawling over 2,753 square feet of refined living space, promises an unparalleled lifestyle backed by a long list of major upgrades completed in the last 3 years. Situated on a picturesque lake front lot, you will experience the privacy of an acre of land, in a community that allows boat and RV parking, with the advantages of being close to entertainment and services in the area!  A gated fence is in place and ready to house all of your toys.  As you step inside, the modern farmhouse charm greets you with a woodburning fireplace and glimpse of the exceptional outdoor living space beyond the living room.  The kitchen is central to the living room, dining room and massive family room with walls of windows that bring the light and lovely scenery into the space.  Three bedrooms and a den are on the first floor.  The fourth bedroom is upstairs and currently being used as a bonus room with a built in bar, pool table and charming outside balcony.  The entire home has undergone significant upgrades in the last several years including a new roof and gutters, entire house re-plumb, new septic tank, whole house filtration system, 2 new HVAC units, hot water heater, impact garage door with automation and security feature, kitchen appliances and SO MUCH MORE.  A full list of updates is available.  Outside, the allure of the Florida sun is perfectly complemented by the saltwater pool, now boasting a new heater, lights, automation system, pump, resurfacing, and tile, ensuring endless enjoyment all year round. The outdoor kitchen provides the perfect entertainment station with an expansive lanai of new pavers providing plenty of room for a large gathering. A separate cozy fire pit area will set the stage for memorable gatherings under the stars.  An addiitonal shed with electrical service gives the handyman in the family room to work.  Mill Creek is a unique community with large lots and a variety of architectural designs uncommon in today's marketplace. This house does not just offer upgrades; it promises a lifestyle that is hard to find:  An acre of privacy with an upgraded pool home that has no CDD, low HOA, allows boat and RV parking AND is close to shopping, restaurants, entertainment, schools and everything the area has to offer.  You will love it!

Mary Michael Martin

Welcome to this bright, spacious and charming 2-story, 3-bedroom, 2.5-bath home with a picturesque pond view. Nestled in the tranquil, sought-after neighborhood of Briarwood, this residence offers a perfect blend of comfort and elegance. Briarwood features low HOA fees, two community pools, 10 ponds, and a tennis/pickleball court. Upon entering, you are greeted by a spacious living area adorned with vaulted ceilings and natural light. A three-sided wood-burning fireplace offers relaxing views from multiple rooms. The primary bedroom, conveniently located on the first floor, provides a private retreat offering a luxurious en-suite and an abundance of closet space in the dual closets. Upstairs, a versatile loft awaits, ideal for a home office, media room, or play area. Two additional well-appointed bedrooms and a full bathroom complete the second floor, offering plenty of space for family and guests. The home features a formal dining room, perfect for hosting gatherings and creating lasting memories. The well equipped kitchen offers plenty of counter space, storage, and a breakfast nook overlooking the peaceful pond. An inside laundry room appointed with an abundance of storage cabinets, full sink, and room for an additional refrigerator, leads to an oversized garage with work bench and access to large attic space with flooring. Outside, the backyard oasis beckons with its tranquil views and space for relaxation or outdoor dining. Imagine unwinding on the expansive screened-in lanai while enjoying the soothing sights and sounds of nature. This home combines comfort, style, and a serene setting in a great neighborhood. Located just minutes from SR-70, US-301, US-41, and I-75, it is convenient to SRQ airport, UTC mall shopping, area dining and beautiful gulf coast beaches. Don’t miss the opportunity to make this beautiful water-vista home your own.

5706 29TH COURT E, BRADENTON FL 34203

5706 29TH COURT E, BRADENTON FL 34203

Property Details

Listing Details

Market Trends

Public Records

Mortgage Calculator

National Mortgage Rates

Nearby homes sold recently

Schools

Nearby homes for sale