meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221653' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70652
[post_author] => 4
[post_date] => 2018-11-30 20:30:25
[post_date_gmt] => 2018-11-30 20:30:25
[post_content] => A thin sliver of streets as north as you can be on the west side of town without being in the Presidio. Compared to the Richmond, you'll generally find larger homes on shorter streets with select homes opening up to back-door Presidio access. West Clay is an exclusive enclave of special homes within a special neighborhood.
[post_title] => Lake Street
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lake-street
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 13:15:32
[post_modified_gmt] => 2024-04-09 20:15:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70652
[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, 175 25th 177 Avenue, San Francisco, CA, 94121
ffd_mls_id, 421601286
ffd_salesforce_id, a0E8W00000V0q5JUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 9
of_units__c, 0
address2__c, 175 25th 177 Avenue, San Francisco, CA, 94121
pba__address_pb__c, 175 25th 177 Avenue, San Francisco, CA, 94121
agent_only_remarks__c, For disclosures and showings please email Dana Ward: [email protected]
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1923
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-10-16T16:48:05.000+0000
days_on_market__c, 641
dom__c, 18
ffd_description_pb, What if you could buy a beautifully remodeled home in San Francisco, which also had a completely separate, totally re-built, private cottage house for guests, a home office, in-laws, in-home gym, etc? Too good to be true, right? Nope, here it is! Options abound in this Lake District stunner, which has the perfect open flr plan & flow btwn these two gorgeous homes seamlessly connected by a flat, usable yard. The main house has a totally reno'd custom kit/fmly rm w/ an oversized marble island, heated concrete floors & a frml lvg room with an elegant marble encased fireplace. The upper level consists of 3 bedrooms & 2 luxe, remodeled baths w/ a sprawling primary suite. The 1st lvl of the fully rebuilt, 3 story cottage house has a huge media/rec room w/ a wet bar & connects to the yard. The 2nd level offers an open flr plan with a full kit, lvg rm, dining area & powder rm. At the top level there is an adorable loft bedroom & full bath. One-of-a-kind set up in San Francisco!
district__c, SF District 1
entry_level__c, 0
exterior_features__c, Balcony;Entry Gate
external_listing__c, 1
fencing__c, Back Yard;Fenced
pba__floortype_pb__c, Concrete;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
ffd_lastmodifieddate, 2022-01-25T16:04:46.000+0000
pba__latitude_pb__c, 37.786142
pba__latitude_property__c, 37.786142
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2021-04-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joshua
pba__listing_agent_lastname__c, McAdam
listing_agent_mls_id__c, 902000
ffd_listingagentname, Joshua J McAdam
listing_agent_number__c, 1027476
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 4250000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/630791867
pba__longitude_pb__c, -122.4854278
lower_level__c, Garage,Street Entrance
mls_id__c, 421601286
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-10-16
original_price__c, 4250000
overall_days_on_market__c, 190
parking_access__c, Independent
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-11-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1178.93
pba__propertytype__c, Single Family Residence
id, a0E8W00000V0q5JUAR
sale_date__c, 2021-11-29
sale_price__c, 4085000
selling_agent_mls_id__c, 808044
selling_agent_number__c, 1030093
selling_co_agent_mls_id__c, 802363
selling_co_agent_number__c, 802363
selling_co_office_mls_id__c, PACEDGE
selling_co_office_name__c, Pacific Edge
selling_co_office_number__c, 28507
selling_office_name__c, Pacific Edge
pba__status__c, Closed
pba__totalarea_pb__c, 3465
size__c, 3465
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 25th
subdist__c, Lake Street
ffd_name, 175 25th 177 Avenue, San Francisco, CA, 94121
view__c, Bay;Golden Gate Bridge
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530342764-1.jpg
ListingId, a0E8W00000V0q5JUAR