Array
(
[ID] => 79032
[post_author] => 4
[post_date] => 2018-12-07 02:44:35
[post_date_gmt] => 2018-12-07 02:44:35
[post_content] => White-picket fences surround single-family homes surrounded by a freeway (CA-1/19th Ave.) and six-lane streets. Once upon a time, Lakeside was just a few sleepy homes. Then roads got built. You can visit the library, but if you want to go shopping you’ll need to head all the way north to the end of the neighborhood or across the street to Stonestown.
[post_title] => Lakeside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lakeside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-14 12:34:25
[post_modified_gmt] => 2024-11-14 20:34:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=79032
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 246 Stonecrest Drive, San Francisco, CA, 94132
ffd_mls_id, 421555840
ffd_salesforce_id, a0E1I00000UTxt0UAD
num_of_fireplaces__c, 2
num_of_rooms__c, 9
of_units__c, 0
address2__c, 246 Stonecrest Drive, San Francisco, CA, 94132
pba__address_pb__c, 246 Stonecrest Drive, San Francisco, CA, 94132
agent_only_remarks__c, ON Lockbox! Seller will review all offers on Wednesday, 6/16 by 2p. Previous owner passed away peacefully at the property in November 2018. Call/text with questions. All visitors must comply with Covid guidelines with signed PEAD-ALL. https://app.disclosures.io/link/246-Stonecrest-Drive-p725q4ni Thanks for showing!
appliances__c, Dishwasher;Disposal;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator
bath_features__c, Tile
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1958
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-06-05T18:46:24.000+0000
days_on_market__c, 1305
dom__c, 13
ffd_description_pb, This gorgeous Lakeside home is in a WOW location! Lounge in luxury in this spectacular 5 bedroom and 4 bathroom home. The main level consists of 3 bedrooms, 2 bathrooms, a living room, a dining area and a kitchen. The gourmet kitchen comes equipped with high-end stainless steel appliances, quartz countertops, convection ovens and solid wood cabinets. Featuring motion-sensor lights, the bathrooms have ample cabinet space and stunning fixtures. The lower level consists of a primary suite, an office, a family room with a wet bar and a yoga area. The home also features central heating, a tankless water heater, a laundry room, 2 side-by-side garages and a separate entrance. Conveniently located in a desirable Lakeside neighborhood, this beautiful detached home is near Stonetown Galleria Shopping Mall, San Francisco State University, Lake Merced Park, four Golf Courses, the San Francisco Zoo, Stern Grove Park, Ocean Beach, HWY 280/1, Muni and more.
246 Stonecrest Drive, San Francisco, CA, 94132 - Property Description
This gorgeous Lakeside home is in a WOW location! Lounge in luxury in this spectacular 5 bedroom and 4 bathroom home. The main level consists of 3 bedrooms, 2 bathrooms, a living room, a dining area and a kitchen. The gourmet kitchen comes equipped with high-end stainless steel appliances, quartz countertops, convection ovens and solid wood cabinets. Featuring motion-sensor lights, the bathrooms have ample cabinet space and stunning fixtures. The lower level consists of a primary suite, an office, a family room with a wet bar and a yoga area. The home also features central heating, a tankless water heater, a laundry room, 2 side-by-side garages and a separate entrance. Conveniently located in a desirable Lakeside neighborhood, this beautiful detached home is near Stonetown Galleria Shopping Mall, San Francisco State University, Lake Merced Park, four Golf Courses, the San Francisco Zoo, Stern Grove Park, Ocean Beach, HWY 280/1, Muni and more.
