meta_query='key:subdist__c;value:Lakeside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='372574' 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, 1708170922
ffd_listing_title, 708 Junipero Serra Boulevard, San Francisco, CA, 94127
ffd_mls_id, 423927663
ffd_salesforce_id, a0EUd000000n3zGMAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 8
of_units__c, 0
address2__c, 708 Junipero Serra Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 708 Junipero Serra Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, Lockbox will be placed after first open house on 1/13/24. Please call listing agent for CBS code. Disclosures available replete with receipts for work performed on home. Offers will be due at noon, January 30, 2024, but offers will be reviewed as they come, and may be accepted prior to final offer date if compelling at Seller's sole option. HOA fee applies for the development (currently $68 per year, but may change with HOA discretion). See https://www.lakesidepoa.org/resources for details. Seller will have refrigerator, wall-mounted TV in breakfast nook, and Washer/Dryer removed at seller's cost with Buyer's instruction and Buyer's sole option. If Buyer would like to keep any or all of the appliances mentioned directly above, please note this in offer. Tankless water heater. Combination to in-ground safe in basement available. PREESCROW OPENED WITH Bonnie Hugh at Old Republic Title just around the corner at 2566 Ocean Ave. (415) 570-0864 Escrow # 0216038649-BH
appliances__c, Dishwasher;Hood Over Range;Tankless Water Heater;Free Standing Refrigerator;Double Oven
architectural_style__c, See Remarks
bath_features__c, Tub w/Shower Over;Tile;Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-01-31
cooling__c, None
ffd_createddate, 2024-01-11T11:47:45.000+0000
days_on_market__c, 37
dom__c, 20
ffd_description_pb, This spacious, French Colonial Revival home is truly an unexpected diamond in the rough, & a must see. Built at the cusp of the mid-20th century, this gem artfully demonstrates how form meets function with 4 levels of living space replete with 3 bedrooms, 2 & 1/2 baths in the main quarters & finished basement room with full bath (legality not warranted), exercise room (with wet bar). A large basement with work bench, laundry nook, & generous storage area. Elegant revival accents abound with sweeping staircase onto a grand foyer, crown mouldings, beautifully-maintained hardwood floors, and other period trim. The remodeled kitchen boasts modern appliances (which may remain with unit at Buyer's election), and a breakfast nook with plenty of natural light. The adjoining formal dining room inspires images of holiday dinners, and family toasting and breaking bread. The grand living room with revival-accented fireplace epitomizes elegance as it overlooks landscaped gardens. Each of the main residence's bathrooms is spacious & tastefully remodeled. The master bath features frameless shower door, and a jacuzzi-type tub perfect for relaxing. A lovely rear-garden with patio is adjoined by a covered gardener's workspace below an over-looking mudroom. Lakeside village awaits you!
district__c, SF District 3
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Wood
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, See Remarks
pba__hoafees__c, 68
pba__hoafrequency_pb__c, Annually
hoa_name__c, LAKESIDE PROP. OWNERS ASSOC.
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2024-02-17T11:47:20.000+0000
pba__latitude_pb__c, 37.726379
pba__latitude_property__c, 37.726379
laundry_features__c, In Garage;In Basement;See Remarks;Washer Included;Dryer Included
listed_date__c, 2023-12-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jason
pba__listing_agent_lastname__c, Chu
listing_agent_mls_id__c, 808418
ffd_listingagentname, Jason Chu
listing_agent_number__c, 1034726
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, AMBIANCE
listing_office_name__c, Ambiance Real Estate
listing_office_number__c, 28639
pba__listingprice_pb__c, 2150000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.472659
lower_level__c, Bedroom(s),Full Bath(s),Garage,Living Room,Street Entrance
mls_id__c, 423927663
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Bidet;Jetted Tub;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-01-11
original_price__c, 2150000
overall_days_on_market__c, -81824
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Garage Facing Rear,Interior Access,Tandem Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2024-01-31
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 835.32
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000000n3zGMAQ
road_surface_type__c, Asphalt
roof__c, Bitumen;Shingle
room_type__c, Storage;In Law Apartment
sale_date__c, 2024-02-15
sale_price__c, 2237000
security_features__c, Smoke Detector;Carbon Mon Detector;Other;See Remarks
selling_agent_mls_id__c, EB745840
selling_agent_number__c, 981363989
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Real Estate Experts
pba__status__c, Closed
pba__totalarea_pb__c, 2678
size__c, 2678
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Junipero Serra
subdist__c, Lakeside
ffd_name, 708 Junipero Serra Boulevard, San Francisco, CA, 94127
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
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/530714114-1.jpg