meta_query='key:subdist__c;value:Lakeside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376539' 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, 1714042713
ffd_listing_title, 120 Stonecrest Drive, San Francisco, CA, 94132
ffd_mls_id, 423925230
ffd_salesforce_id, a0EUd000001S0mCMAS
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 120 Stonecrest Drive, San Francisco, CA, 94132
pba__address_pb__c, 120 Stonecrest Drive, San Francisco, CA, 94132
agent_only_remarks__c, This stately home on a significant 12,300 parcel of land is ready to welcome its next owners. Great architectural style and quality construction that is ready for personal updates. Expansion potential within the home's envelope.
appliances__c, Dishwasher;Disposal;Free Standing Refrigerator
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-03-25
ffd_createddate, 2024-03-15T10:47:45.000+0000
days_on_market__c, 41
dom__c, 19
ffd_description_pb, Nestled in the heart of the historic Lakeside neighborhood, 120 Stonecrest emanates timeless beauty and enduring grace. Built in 1941 and cherished by the same family for decades, this residence offers 3,500 square feet of living space on a sprawling 12,300 square-foot lot, creating a haven for seamless indoor/outdoor living within a secluded compound. Step inside to discover oversized windows that bathe the spacious and elegant living room, a grand formal dining room, and a welcoming foyer in natural light. With 4-5 generously sized bedrooms and 3.5 baths, each offering ample privacy and separation, this home ensures comfort and tranquility for all residents. Conveniently located within walking distance of numerous Lakeside attractions, including the Winston Street public library and the nearby Stonestown Galleria, this property also boasts proximity to exceptional schools and public transportation, enriching the vibrant lifestyle this neighborhood offers. Welcome to your forever home at 120 Stonecrest, where every detail whispers of a lifetime of cherished memories awaiting you.
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway,Sidewalk/Curb/Gutter
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Piped
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Other
pba__hoafees__c, 68
pba__hoafrequency_pb__c, Annually
hoa_name__c, Lakeside Property Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-04-25T10:47:01.000+0000
pba__latitude_pb__c, 37.728392
pba__latitude_property__c, 37.728392
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2023-12-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Barnacle
listing_agent_mls_id__c, 808652
ffd_listingagentname, Michael J Barnacle
listing_agent_number__c, 1037458
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28936
pba__listingprice_pb__c, 2975000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=pzFH3aJvBMs&mls=1
pba__longitude_pb__c, -122.474367
mls_id__c, 423925230
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-03-15
original_price__c, 2975000
overall_days_on_market__c, -81888
parking_access__c, Independent
parking_features__c, 24'+ Deep Garage,Attached,Garage Door Opener,Guest Parking Available,Interior Access,Uncovered Parking Spaces 2+,Workshop in Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-04-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 849.27
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001S0mCMAS
roof__c, Shingle
sale_date__c, 2024-04-23
sale_price__c, 2975000
selling_agent_mls_id__c, 811044
selling_agent_number__c, 1049436
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 3503
size__c, 3503
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Stonecrest
subdist__c, Lakeside
ffd_name, 120 Stonecrest Drive, San Francisco, CA, 94132
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530745179-1.jpg