meta_query='key:subdist__c;value:Lakeside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385844' posts_per_page=4 post_type=property
bool(false)
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-04-09 12:09:54
[post_modified_gmt] => 2024-04-09 19:09:54
[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
(
)
)
_yoast_indexnow_last_ping, 1728089709
ffd_listing_title, 270 Stonecrest Drive, San Francisco, CA, 94132
ffd_mls_id, 424063203
ffd_salesforce_id, a0EUd0000032vi8MAA
num_of_fireplaces__c, 2
num_of_rooms__c, 9
of_units__c, 0
address2__c, 270 Stonecrest Drive, San Francisco, CA, 94132
pba__address_pb__c, 270 Stonecrest Drive, San Francisco, CA, 94132
agent_only_remarks__c, Email [email protected] with any questions or for disclosure requests. Supra installed on railing by front door.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1959
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Austin Cheng
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-06T17:47:23.000+0000
days_on_market__c, 28
dom__c, 28
ffd_description_pb, Located in the peaceful Lakeside District, this detached 4-bed, 3-bath home boasts 2,450 sq ft of elegant living space. Inside, enjoy rich hardwood floors, custom shutters & recessed lighting. The sunlit living room features large windows and a tiled fireplace, perfect for cozy evenings. The kitchen offers sleek granite countertops, oak cabinetry, dual ovens & a breakfast nook, with a separate dining room for larger gatherings. The hallway leads to three spacious bedrooms, including a primary suite with dual closets and an updated ensuite bath. A spa-like hall bathroom includes a glass-enclosed shower & soaking tub. The expansive lower level is an entertainer's dream, featuring a family room with a brick fireplace, wet bar, and sliding glass doors opening to the backyard. This level also includes a fourth bedroom, an additional bath, a laundry area, and a bonus room previously used as a home theater. A two-car garage, additional driveway spaces, and ample storage complete the home. Conveniently located across from Stonestown Galleria, enjoy nearby dining, shopping & entertainment, including Target, Trader Joe's, Whole Foods, and the Farmers Market. Close proximity to parks, schools, Stern Grove, Lake Merced, combined with easy access to public transportation & freeways.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Family Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Floor Furnace
ffd_lastmodifieddate, 2024-10-05T00:47:16.000+0000
pba__latitude_pb__c, 37.7258134
pba__latitude_property__c, 37.7258134
laundry_features__c, Hookups Only
listed_date__c, 2024-09-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kelvin
pba__listing_agent_lastname__c, Kam
listing_agent_mls_id__c, 806118
ffd_listingagentname, Kelvin Kam
listing_agent_number__c, 166016307
listing_co_agent_mls_id__c, MLSL5100998
listing_co_agent_number__c, 981404977
listing_co_office_mls_id__c, SQRE-1
listing_co_office_name__c, Sequoia Real Estate
listing_co_office_number__c, 981052534
listing_office_mls_id__c, SQRE
listing_office_name__c, Sequoia Real Estate
listing_office_number__c, 28627
pba__listingprice_pb__c, 1895000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.47449
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 424063203
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-09-06
open_house_end__c, 2024-10-06T16:00:00.000+0000
open_house_start__c, 2024-10-06T14:00:00.000+0000
original_price__c, 1895000
overall_days_on_market__c, -82063
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Side-by-Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 773.47
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000032vi8MAA
roof__c, Bitumen;Shingle
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 2450
size__c, 2450
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Stonecrest
subdist__c, Lakeside
ffd_name, 270 Stonecrest Drive, San Francisco, CA, 94132
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Dual Pane Partial
pba__yearbuilt_pb__c, 1959
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530837771-1.jpg