Demo/Test Data 16574 Zumaque, Rancho Santa Fe, CA 92067
Demo/Test Data 16574 Zumaque, Rancho Santa Fe, CA 92067
$489,999
Overview
Property ID: HZ4178671843288087085247
Residential, Residential
Property Type
4
Bedrooms
2
Bathrooms
2
Garages
Description
Demo/Test Data **This listings is for DEMO/TEST purpose only** The picture-perfect home you’ve been dreaming about is here! Welcome to The Hawthorne House. A beautiful 4-bedroom, 2-bath Cape that has been completely renovated and professionally designed from top to bottom with high-end finishes and attention to every detail. Features an HGTV-style kitchen with ** To get a real data, please visit https://dashboard.realtyfeed.com
⇄⧉public PublicRemarks -> string (1222) "Located just minutes from the heart of Gainesville and only a few miles (12-...
$admin_bar_single_raw_data->PublicRemarks
Located just minutes from the heart of Gainesville and only a few miles (12-minute bike ride) from the University of Florida, this solid block 4-bedroom, 3-bathroom home offers the perfect blend of comfort, convenience and investment potential. Featuring a spacious layout with large living and dining area, eat-in kitchen, this home provides plenty of room for family, guests, or roommates. Seller is installing brand-new, custom-made cabinet doors and refinishing cabinet boxes in the kitchen. The unique layout allows for the home to be separated into a DUPLEX if desired, with the exception of an additional kitchen. 2 front doors allow for 2 families to live under 1 roof if the kitchen situation can be navigated......or a kitchen can be added. Zoning for duplex would need to be verified by the zoning dept. This home also has a fenced-in large backyard with a deck for grilling and enjoying the outdoors. Enjoy easy access to shopping, dining, medical facilities, and all that Gainesville provides while being tucked into an established neighborhood just a few blocks off of US 441. Whether you are searching for your primary residence, game day getaway, or rental opportunity near UF, this property is a must-see!
⇄⧉public Directions -> string (184) "From I-75 get off at exit 387 (Newberry Road). Go east on Newberry road unti...
$admin_bar_single_raw_data->Directions
From I-75 get off at exit 387 (Newberry Road). Go east on Newberry road until you reach US411 (13th St). Go north on 13th until you reach NW 21st Ave. House is third down on your left.
Located just minutes from the heart of Gainesville and only a few miles (12-minute bike ride) from the University of Florida, this solid block 4-bedroom, 3-bathroom home offers the perfect blend of comfort, convenience and investment potential. Featuring a spacious layout with large living and dining area, eat-in kitchen, this home provides plenty of room for family, guests, or roommates. Seller is installing brand-new, custom-made cabinet doors and refinishing cabinet boxes in the kitchen. The unique layout allows for the home to be separated into a DUPLEX if desired, with the exception of an additional kitchen. 2 front doors allow for 2 families to live under 1 roof if the kitchen situation can be navigated......or a kitchen can be added. Zoning for duplex would need to be verified by the zoning dept. This home also has a fenced-in large backyard with a deck for grilling and enjoying the outdoors. Enjoy easy access to shopping, dining, medical facilities, and all that Gainesville provides while being tucked into an established neighborhood just a few blocks off of US 441. Whether you are searching for your primary residence, game day getaway, or rental opportunity near UF, this property is a must-see!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 4178671843288087085247 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (432) "Demo/Test Data **This listings is for DEMO/TEST purpose only** The picture-p...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 4178671843288087085247 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->PublicRemarks
Demo/Test Data **This listings is for DEMO/TEST purpose only** The picture-perfect home you've been dreaming about is here! Welcome to The Hawthorne House. A beautiful 4-bedroom, 2-bath Cape that has been completely renovated and professionally designed from top to bottom with high-end finishes and attention to every detail. Features an HGTV-style kitchen with ** To get a real data, please visit https://dashboard.realtyfeed.com
new \Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse($body)
/**
* RFResponse constructor.
*/
Defined in <ROOT>/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/RFClient/SDK/RF/RFResponse.php:43
⇄RF Response Time => string (12) "0.07 seconds"
Located just minutes from the heart of Gainesville and only a few miles (12-minute bike ride) from the University of Florida, this solid block 4-bedroom, 3-bathroom home offers the perfect blend of comfort, convenience and investment potential. Featuring a spacious layout with large living and dining area, eat-in kitchen, this home provides plenty of room for family, guests, or roommates. Seller is installing brand-new, custom-made cabinet doors and refinishing cabinet boxes in the kitchen. The unique layout allows for the home to be separated into a DUPLEX if desired, with the exception of an additional kitchen. 2 front doors allow for 2 families to live under 1 roof if the kitchen situation can be navigated......or a kitchen can be added. Zoning for duplex would need to be verified by the zoning dept. This home also has a fenced-in large backyard with a deck for grilling and enjoying the outdoors. Enjoy easy access to shopping, dining, medical facilities, and all that Gainesville provides while being tucked into an established neighborhood just a few blocks off of US 441. Whether you are searching for your primary residence, game day getaway, or rental opportunity near UF, this property is a must-see!
From I-75 get off at exit 387 (Newberry Road). Go east on Newberry road until you reach US411 (13th St). Go north on 13th until you reach NW 21st Ave. House is third down on your left.
Located just minutes from the heart of Gainesville and only a few miles (12-minute bike ride) from the University of Florida, this solid block 4-bedroom, 3-bathroom home offers the perfect blend of comfort, convenience and investment potential. Featuring a spacious layout with large living and dining area, eat-in kitchen, this home provides plenty of room for family, guests, or roommates. Seller is installing brand-new, custom-made cabinet doors and refinishing cabinet boxes in the kitchen. The unique layout allows for the home to be separated into a DUPLEX if desired, with the exception of an additional kitchen. 2 front doors allow for 2 families to live under 1 roof if the kitchen situation can be navigated......or a kitchen can be added. Zoning for duplex would need to be verified by the zoning dept. This home also has a fenced-in large backyard with a deck for grilling and enjoying the outdoors. Enjoy easy access to shopping, dining, medical facilities, and all that Gainesville provides while being tucked into an established neighborhood just a few blocks off of US 441. Whether you are searching for your primary residence, game day getaway, or rental opportunity near UF, this property is a must-see!
A rare opportunity in the gated community of Brookstone! Situated on 1.09 acres, this custom-built 2007 home offers just under 4,500 square feet of living space with 5 bedrooms, 3 full baths and 2 half baths, along with a tile roof, whole-house generator and an impressive combination of space, character and thoughtful custom features.
One of the home's most memorable features is its architecturally distinctive main living space, where a curved wall of windows fills the room with natural light and creates multiple areas for gathering, conversation and relaxation. A centrally positioned gas fireplace serves as a striking focal point and adds to the truly custom character of the space.
The spacious gourmet kitchen features granite countertops, abundant cabinetry, a large center island, multiple pantries, a gas range and dual ovens, including a convection oven. An adjoining breakfast area provides plenty of room for casual dining, while the separate formal dining room with crown molding offers a more traditional setting for entertaining.
The first floor also includes a private office with an adjoining half bath, plus a bedroom and full bath — an excellent arrangement for overnight guests or multigenerational living.
Upstairs, the oversized primary suite features a double inset tray ceiling with crown molding, generous walk-in closets and a spacious private bath. The additional bedrooms offer excellent closet space, including walk-in closets, while the upstairs laundry is conveniently located near the bedrooms. An additional den/flex space opens directly onto a covered second-floor balcony, creating an inviting spot for a second living area, reading room, hobby space or private retreat.
Outdoor living continues with a covered front porch, rear patio and outdoor kitchen, all surrounded by more than an acre of property. Additional highlights include natural gas, a whole-house generator and a separate air-conditioned storage room within the garage, providing valuable temperature-controlled space for storage, hobbies or collectibles.
With its distinctive architecture, generous room sizes, exceptional storage, tile roof, expansive homesite and hard-to-find location within gated Brookstone, this custom home offers a combination of space, functionality and character you simply don't find in many newer homes.
⇄⧉public Appliances -> string (93) "Convection Oven,Cooktop,Dishwasher,Dryer,Gas Water Heater,Microwave,Range,Re...
From S. Pine Ave (US 441) Head West on SE 32nd St., T/L onto SE 3rd Ave. Go 1/4 mile T/L into the Brookstone entrance at SE 36th Lane. Follow around curve toward back of neighborhood property on Right.
A rare opportunity in the gated community of Brookstone! Situated on 1.09 acres, this custom-built 2007 home offers just under 4,500 square feet of living space with 5 bedrooms, 3 full baths and 2 half baths, along with a tile roof, whole-house generator and an impressive combination of space, character and thoughtful custom features.
One of the home's most memorable features is its architecturally distinctive main living space, where a curved wall of windows fills the room with natural light and creates multiple areas for gathering, conversation and relaxation. A centrally positioned gas fireplace serves as a striking focal point and adds to the truly custom character of the space.
The spacious gourmet kitchen features granite countertops, abundant cabinetry, a large center island, multiple pantries, a gas range and dual ovens, including a convection oven. An adjoining breakfast area provides plenty of room for casual dining, while the separate formal dining room with crown molding offers a more traditional setting for entertaining.
The first floor also includes a private office with an adjoining half bath, plus a bedroom and full bath — an excellent arrangement for overnight guests or multigenerational living.
Upstairs, the oversized primary suite features a double inset tray ceiling with crown molding, generous walk-in closets and a spacious private bath. The additional bedrooms offer excellent closet space, including walk-in closets, while the upstairs laundry is conveniently located near the bedrooms. An additional den/flex space opens directly onto a covered second-floor balcony, creating an inviting spot for a second living area, reading room, hobby space or private retreat.
Outdoor living continues with a covered front porch, rear patio and outdoor kitchen, all surrounded by more than an acre of property. Additional highlights include natural gas, a whole-house generator and a separate air-conditioned storage room within the garage, providing valuable temperature-controlled space for storage, hobbies or collectibles.
With its distinctive architecture, generous room sizes, exceptional storage, tile roof, expansive homesite and hard-to-find location within gated Brookstone, this custom home offers a combination of space, functionality and character you simply don't find in many newer homes.
Let the fun begin and the income flow. Private pickleball court, pool and spa, oversized corner lot, and an unbeatable location, this 3-bedroom, 2 full and 1 half bath home delivers the ultimate laid-back Florida lifestyle while checking every box. Designed for entertaining, the backyard is the true showpiece, featuring a sparkling pool and spa, private pickleball court, basketball area, gazebo, fire pit, generous yard space, and a convenient poolside half bath that keeps the fun outdoors. Ideally located just minutes steps from local favorites and minutes from downtown St. Petersburg, charming Gulfport, award-winning Gulf beaches, local restaurants, shopping, and everyday conveniences, this turnkey property is the perfect investment opportunity, vacation home, or full-time Florida retreat. Currently operating as a successful short-term rental with rental history available upon request, the home is ready to enjoy or begin generating income from day one. Situated on an oversized 79' x 160' fenced corner lot, the property offers 1,588 heated square feet of thoughtfully designed and easily maintained living space featuring tile, wood and laminate flooring (no carpet!), neutral finishes, white cabinetry, stainless steel appliances, a dedicated dining area, interior laundry, and a versatile Florida room off the kitchen that's perfect for casual dining, entertaining, or a convenient drop zone. The spacious primary suite features a walk-in closet, soaking tub, and separate walk-in shower, while the living room and one guest bedroom open through sliding glass doors, creating a seamless connection to the outdoor living spaces. A double side-entry gate provides easy access for boat, RV, or trailer storage. Located in Flood Zone X, with no flood insurance required and no flooding reported by the sellers, this exceptional property offers peace of mind while placing you just minutes from everything that makes St. Petersburg one of Florida's most sought-after destinations. Sold fully furnished and rental ready! Seller financing available with 30% down minimum, requirements, terms and conditions to be determined by owner.
One block away from intersection of Pasadena Ave & Central Ave. From West on Central Avenue, Turn right onto Pasadena Avenue North, then take the immediate left onto Pinellas Way North. Continue a short distance, and the property will be located on your left.
Let the fun begin and the income flow. Private pickleball court, pool and spa, oversized corner lot, and an unbeatable location, this 3-bedroom, 2 full and 1 half bath home delivers the ultimate laid-back Florida lifestyle while checking every box. Designed for entertaining, the backyard is the true showpiece, featuring a sparkling pool and spa, private pickleball court, basketball area, gazebo, fire pit, generous yard space, and a convenient poolside half bath that keeps the fun outdoors. Ideally located just minutes steps from local favorites and minutes from downtown St. Petersburg, charming Gulfport, award-winning Gulf beaches, local restaurants, shopping, and everyday conveniences, this turnkey property is the perfect investment opportunity, vacation home, or full-time Florida retreat. Currently operating as a successful short-term rental with rental history available upon request, the home is ready to enjoy or begin generating income from day one. Situated on an oversized 79' x 160' fenced corner lot, the property offers 1,588 heated square feet of thoughtfully designed and easily maintained living space featuring tile, wood and laminate flooring (no carpet!), neutral finishes, white cabinetry, stainless steel appliances, a dedicated dining area, interior laundry, and a versatile Florida room off the kitchen that's perfect for casual dining, entertaining, or a convenient drop zone. The spacious primary suite features a walk-in closet, soaking tub, and separate walk-in shower, while the living room and one guest bedroom open through sliding glass doors, creating a seamless connection to the outdoor living spaces. A double side-entry gate provides easy access for boat, RV, or trailer storage. Located in Flood Zone X, with no flood insurance required and no flooding reported by the sellers, this exceptional property offers peace of mind while placing you just minutes from everything that makes St. Petersburg one of Florida's most sought-after destinations. Sold fully furnished and rental ready! Seller financing available with 30% down minimum, requirements, terms and conditions to be determined by owner.
Nestled in the highly coveted Courtlea Oaks community, within Winter Garden’s sought-after golf cart district, this beautifully updated home offers the perfect blend of timeless charm and modern luxury. Enjoy the lifestyle that has made historic downtown Winter Garden one of Central Florida’s most beloved destinations—just minutes away you’ll find award-winning restaurants, boutique shopping, the renowned Saturday Farmers Market, live entertainment, festivals, and miles of the West Orange Trail.
Situated on an oversized .33-acre homesite, this exceptional residence offers 2,765 square feet with three bedrooms, two-and-a-half baths, and thoughtfully designed living spaces filled with architectural character.
From the moment you enter, you’ll be welcomed by soaring ceilings, rich hardwood flooring, custom board-and-batten millwork, crown molding, and a stunning two-story foyer that creates an unforgettable first impression.
At the heart of the home is a beautifully renovated kitchen featuring custom white cabinetry, a center island, farmhouse sink, professional-style gas range with pot filler, stainless steel appliances, and generous workspace—perfectly designed for both everyday living and effortless entertaining. The kitchen flows seamlessly into the spacious family room and sun-filled dining area overlooking the backyard oasis.
Upstairs, the expansive loft provides exceptional flexibility as a media room, home office, fitness space, or could easily accommodate a fourth bedroom. The secondary bedrooms are generously sized, including one with a charming custom-built window desk. The beautifully updated bathrooms continue the home’s timeless design with quality finishes throughout.
Step outside to your own private retreat featuring a sparkling pool, expansive brick paver deck, lush landscaping, and plenty of room for entertaining or simply relaxing under the Florida sun.
Homes in Courtlea Oaks are rarely available. Combining an exceptional location, beautiful updates, timeless architecture, and one of Winter Garden’s most desirable lifestyles, this is a home you’ll be proud to call your own.
⇄public Appliances -> string (73) "Dishwasher,Disposal,Dryer,Electric Water Heater,Range,Refrigerator,Washer"
Heading South on FL-429, take exit 24 for Plant Street. Turn right onto Plant St. Turn right onto N Dillard Street. Turn right onto Courtlea Oaks Blvd. Turn left onto Forest Haven Dr. Turn right onto Valley View Dr. Home is on the left.
⇄public ElementarySchool -> string (19) "Dillard Street Elem"
Nestled in the highly coveted Courtlea Oaks community, within Winter Garden’s sought-after golf cart district, this beautifully updated home offers the perfect blend of timeless charm and modern luxury. Enjoy the lifestyle that has made historic downtown Winter Garden one of Central Florida’s most beloved destinations—just minutes away you’ll find award-winning restaurants, boutique shopping, the renowned Saturday Farmers Market, live entertainment, festivals, and miles of the West Orange Trail.
Situated on an oversized .33-acre homesite, this exceptional residence offers 2,765 square feet with three bedrooms, two-and-a-half baths, and thoughtfully designed living spaces filled with architectural character.
From the moment you enter, you’ll be welcomed by soaring ceilings, rich hardwood flooring, custom board-and-batten millwork, crown molding, and a stunning two-story foyer that creates an unforgettable first impression.
At the heart of the home is a beautifully renovated kitchen featuring custom white cabinetry, a center island, farmhouse sink, professional-style gas range with pot filler, stainless steel appliances, and generous workspace—perfectly designed for both everyday living and effortless entertaining. The kitchen flows seamlessly into the spacious family room and sun-filled dining area overlooking the backyard oasis.
Upstairs, the expansive loft provides exceptional flexibility as a media room, home office, fitness space, or could easily accommodate a fourth bedroom. The secondary bedrooms are generously sized, including one with a charming custom-built window desk. The beautifully updated bathrooms continue the home’s timeless design with quality finishes throughout.
Step outside to your own private retreat featuring a sparkling pool, expansive brick paver deck, lush landscaping, and plenty of room for entertaining or simply relaxing under the Florida sun.
Homes in Courtlea Oaks are rarely available. Combining an exceptional location, beautiful updates, timeless architecture, and one of Winter Garden’s most desirable lifestyles, this is a home you’ll be proud to call your own.
new \Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse($body)
/**
* RFResponse constructor.
*/
Defined in <ROOT>/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/RFClient/SDK/RF/RFResponse.php:43
⇄RF Response Time => string (12) "0.06 seconds"