meta_query='key:subdist__c;value:Lakeside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='372562' 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, 1708170919
ffd_listing_title, 800 Junipero Serra Boulevard, San Francisco, CA, 94127
ffd_mls_id, 423925773
ffd_salesforce_id, a0EUd000000m910MAA
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 800 Junipero Serra Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 800 Junipero Serra Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, So much more to say so visit the web site! Disclosures are ready. Ready to show Supra on the front door. Please text me to let me know you're going. Please be sure to shut all the lights before leaving and secure doors but do not lock interior door to garage. Offers will be accepted on tuesday 1/23 by 3:00 PM (sorry I know its tour day) Offers to be submitted on Disclosures.io Please use SFAR forms.
appliances__c, Dishwasher;Built-In Gas Range;Built-In Gas Oven;Double Oven;Built-In Refrigerator
architectural_style__c, Traditional;Mid-Century
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-01-10T01:46:18.000+0000
days_on_market__c, 39
dom__c, 14
ffd_description_pb, Welcome to a classic home in the heart of San Francisco's Lakeside district. This gracious three-bedroom, three-bath mid-century home invites you into a world of charm and elegance across its three levels. As you enter, you are greeted by the warmth of beautiful hardwood floors that span throughout the house. The living spaces boast classic mid-century charm with exquisite tray ceilings, creating an inviting atmosphere for both relaxation and entertaining. The heart of the home lies in the modern kitchen, a culinary haven featuring a gas range, double ovens, and sleek granite countertops. Whether you're a seasoned chef or just enjoy hosting gatherings, this kitchen is sure to inspire culinary delights and memorable moments. There is handy breakfast bar for casual morning coffee and breakfast. With three bedrooms spread across the upper split level, each offering ample space and natural light, this residence provides a perfect balance of privacy and togetherness. The three well-appointed bathrooms ensure convenience and comfort for everyone. On the lower level there is a charming wood paneled den that could function as a fourth bedroom easily as it is serviced by the third full bathroom on this floor. However the convenient wet bar says it could be so much more!
district__c, SF District 3
entry_level__c, 0
exterior_features__c, Wet Bar
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Bamboo;Wood
hoa_fee_includes__c, None
pba__hoafees__c, 68
pba__hoafrequency_pb__c, Annually
hoa_name__c, Lakeside Property Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-02-17T11:47:20.000+0000
pba__latitude_pb__c, 37.7236765
pba__latitude_property__c, 37.7236765
laundry_features__c, In Garage;Washer/Dryer Stacked Included
listed_date__c, 2023-12-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sandra
pba__listing_agent_lastname__c, Gandolfo
listing_agent_mls_id__c, 803790
ffd_listingagentname, Sandy Gandolfo
listing_agent_number__c, 803790
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 1895000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.lakesidepoa.org/
pba__longitude_pb__c, -122.4727619
lower_level__c, Family Room,Full Bath(s)
mls_id__c, 423925773
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Jetted Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-01-09
original_price__c, 1895000
overall_days_on_market__c, -81822
parking_access__c, Independent
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Deck
pba__pendingdate__c, 2024-01-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-02-16T15:10:25.000+0000
price_per_square_foot__c, 931.82
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000000m910MAA
road_surface_type__c, Asphalt
room_type__c, Storage;Den;Kitchen;Living Room;Dining Room;Possible Guest;Workshop;Primary Bathroom;Primary Bedroom
sale_date__c, 2024-02-16
sale_price__c, 2050000
selling_agent_mls_id__c, 516371
selling_agent_number__c, 516371
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 2200
size__c, 2200
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Junipero Serra
subdist__c, Lakeside
ffd_name, 800 Junipero Serra Boulevard, San Francisco, CA, 94127
view__c, City
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530710302-1.jpg