meta_query='key:subdist__c;value:Lakeside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218577' 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
(
)
)
ffd_listing_title, 35 Broadmoor Drive, San Francisco, CA, 94132
ffd_mls_id, 421543905
ffd_salesforce_id, a0E1I00000USMeKUAX
num_of_fireplaces__c, 0
num_of_rooms__c, 9
of_units__c, 0
address2__c, 35 Broadmoor Drive, San Francisco, CA, 94132
pba__address_pb__c, 35 Broadmoor Drive, San Francisco, CA, 94132
agent_only_remarks__c, Please contact Gregory Goldstein for all showings (415-412-9400; [email protected]). Showings are by private appointment following SFAR COVID-19 guidelines. Showing agent must submit: 1. signed PEAD (CAR or brokerage version) for all buyers and agents viewing the unit, and all buyers and agents viewing the unit must: 2. review CAR Posted Rules for Entry. Please use Escrow opened with Helen Dumont at ORTC on Ocean Ave, E#0216034036. AS-IS. Lakeside Property Owners Association (LPOA) at: https://www.lakesidepoa.org. Please email for disclosures. Please use SF Purchase Agreement.
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1942
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-30T10:48:04.000+0000
days_on_market__c, 811
dom__c, 22
ffd_description_pb, This spectacular 5-br, 3.5-ba detached Lakeside home has been extensively renovated showcasing high end finishes, top-of-the line appliances & fixtures. Classic floor plan. Main floor features spectacular foyer with palatial sky-lit staircase. Immaculate hardwood floors. Airy spacious living room with fireplace opens-up to the back yard with large deck perfect for outdoor activities. Bright formal dining room flows to a formal breakfast room and kitchen (s/steel appliances, granite). There is also one bedroom and a partial bathroom on this level. Upper level has 4br/3ba. Grand master bedroom with walk-in closet and dramatic en-suite marbled bathroom, another master bedroom with separate entrance has an en-suite bath and a walking closet. Laundry room. 2-car garage + 1 off street parking. Manicured front and back yard lawns. Close to West Portal shops and restaurants, Stonestown galleria, public transportation and easy FWY access.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 68
pba__hoafrequency_pb__c, Annually
hoa_name__c, Lakeside Home Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-01-25T15:51:05.000+0000
pba__latitude_pb__c, 37.7279864
pba__latitude_property__c, 37.7279864
listed_date__c, 2021-04-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gregory
pba__listing_agent_lastname__c, Goldstein
listing_agent_mls_id__c, 115139
ffd_listingagentname, Gregory Goldstein
listing_agent_number__c, 115139
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CSRI
listing_office_name__c, California State Realty, Inc.
listing_office_number__c, 940
pba__listingprice_pb__c, 2800000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4729513
mls_id__c, 421543905
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-04-29
original_price__c, 2800000
overall_days_on_market__c, 124
parking_access__c, Side by Side
parking_features__c, Alley Access,Enclosed,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-05-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 956.23
pba__propertytype__c, Single Family Residence
id, a0E1I00000USMeKUAX
sale_date__c, 2021-07-09
sale_price__c, 2600000
selling_agent_mls_id__c, 800407
selling_agent_number__c, 800407
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2719
size__c, 2719
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Broadmoor
subdist__c, Lakeside
ffd_name, 35 Broadmoor Drive, San Francisco, CA, 94132
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1942
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530229106-1.jpg
ListingId, a0E1I00000USMeKUAX