meta_query='key:subdist__c;value:Lakeside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='234177' 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, 620 Junipero Serra Boulevard, San Francisco, CA, 94127
ffd_mls_id, 491534
ffd_salesforce_id, a0E1I00000ITw8IUAT
address2__c, 620 Junipero Serra Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 620 Junipero Serra Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, Email [email protected] for questions and showings. 2,384 sqft per tax record. Buyer to investigate legality of lower master suite.
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
ffd_createddate, 2019-10-18T19:46:32.000+0000
days_on_market__c, 1370
dom__c, 17
ffd_description_pb, This grand-scale 3 BD 3.5 BA home in Lakeside offers traditional elegance in a flexible, 2+level floor plan with refined finishes, wonderful curb appeal, and a massive 6,128 sq. ft. lot. Spread over 3,215 sq. ft. of living space, the home features original hardwood flooring in common areas; custom window treatments and crown molding; plus spacious, professionally landscaped front and rear yards. Also included are a charming chef's kitchen; a well-sized formal living room with wood burning fireplace; a formal dining room; family room; and 3 bedroom suites with full baths (including the luxurious grand master suite with spa-like bath). On the lower floor is an additional suite with a full bath, 1-car parking, and a laundry room with storage. Located just blocks from the Stonestown Galleria and SFSU. Outstanding access to all daily necessities, and an easy commute to the South Bay or downtown. 1-car parking, laundry, storage, and access to a semi-private service alley included
district__c, SF District 3
external_listing__c, 1
hoa_dues__c, 0
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-03-01T20:29:40.000+0000
pba__latitude_pb__c, 37.7274801
pba__latitude_property__c, 37.7274801
listed_date__c, 2019-10-18
pba__listing_agent_firstname__c, Todd
pba__listing_agent_lastname__c, Montgomery
listing_agent_mls_id__c, 807753
listing_agent_number__c, 1025356
listing_co_agent_mls_id__c, 804756
listing_co_agent_number__c, 166014430
listing_co_office_mls_id__c, COMP4
listing_co_office_name__c, Compass
listing_co_office_number__c, 27592
listing_office_mls_id__c, COMP4
listing_office_name__c, Compass
listing_office_number__c, 27592
pba__listingprice_pb__c, 1950000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.620JuniperoSerra.com
pba__longitude_pb__c, -122.4725954
pba__lotsize_pb__c, 0.14
mls_id__c, 491534
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2019-10-18
original_price__c, 1950000
overall_days_on_market__c, 1370
parking__c, Attached,Garage,Interior Access
parking_type__c, On Site
price_per_square_foot__c, 606.53
pba__propertytype__c, Single-Family Home
id, a0E1I00000ITw8IUAT
sale_date__c, 2019-11-15
sale_price__c, 1950000
selling_agent_mls_id__c, 373992
selling_agent_name__c, Eric D. Altree
selling_agent_number__c, 373992
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, 3215
size__c, 3215
pba__state_pb__c, CA
pba__street_pb__c, Junipero Serra
subdist__c, Lakeside
ffd_name, 620 Junipero Serra Boulevard, San Francisco, CA, 94127
transportation__c, 2 Blocks
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/357448-1.jpg
ListingId, a0E1I00000ITw8IUAT