meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211635' 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, 172 4th 174 Avenue, San Francisco, CA, 94118
ffd_mls_id, 421613441
ffd_salesforce_id, a0E8W00000V1y2CUAR
num_of_rooms__c, 10
of_units__c, 3
address2__c, 172 4th 174 Avenue, San Francisco, CA, 94118
pba__address_pb__c, 172 4th 174 Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Trust Sale. Pre-Escrow opened with Old Republic Title, Karen Tam - Escrow #1127025118-KT. Disclosure link: https://app.disclosures.io/link/172174-4th-Ave-jx2ios4w **Offers if any due Monday, Dec 6 @2pm.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Free Standing Gas Oven;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 5
year_build_text__c, 1920
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jade Kwan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-11-23T11:48:13.000+0000
days_on_market__c, 603
dom__c, 14
ffd_description_pb, The beautifully renovated, 1920's era building, 172 and 174 Fourth Avenue, San Francisco is located in the heart of the Inner Richmond district between California and Lake. The building is comprised of two spacious full-floor flats with 2 bedrooms, 1.5 bathrooms and a non-conforming one bedroom apartment. The property is conveniently located and provides access to every local amenity including, Mountain Lake Park, Golden Gate Park, the Presidio, weekly Farmer's Market, several amazing beaches and wonderful shopping and restaurants along Clement Street and in Laurel Village. The local elementary school is very well rated and public transit is easily accessible. Each of the units is currently vacant and available to be occupied by the owner or leased at market rental rates. The entire building is +/- 3,400 square feet and is built to the lot lines; enjoy morning coffee in the outdoor living areas on the sunny decks. The property includes a one car garage with a common laundry room.
district__c, SF District 1
electric__c, 220 Volts
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2022-01-25T13:34:59.000+0000
pba__latitude_pb__c, 37.785673
pba__latitude_property__c, 37.785673
laundry_features__c, In Common Area
listed_date__c, 2021-11-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Corinne
pba__listing_agent_lastname__c, Ng
listing_agent_mls_id__c, 802976
ffd_listingagentname, Corinne Ng
listing_agent_number__c, 802976
listing_co_agent_mls_id__c, 804624
listing_co_agent_number__c, 166014250
listing_co_office_mls_id__c, JODI
listing_co_office_name__c, JODI Group
listing_co_office_number__c, 15618
listing_office_mls_id__c, CORT
listing_office_name__c, Corterra Real Estate, Inc.
listing_office_number__c, 166013425
pba__listingprice_pb__c, 2750000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.462249
mls_id__c, 421613441
master_property__c, a0O8W00000DaDzAUAV
parkingspaces__c, 1
on_market_date__c, 2021-11-23
original_price__c, 2750000
overall_days_on_market__c, 97
parking_features__c, Attached,Garage
pba__pendingdate__c, 2021-12-07
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 929.11
pba__propertytype__c, Duplex
id, a0E8W00000V1y2CUAR
sale_date__c, 2022-01-07
sale_price__c, 2700000
security_features__c, Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 814555
selling_agent_number__c, 1067076
selling_co_agent_mls_id__c, 815055
selling_co_agent_number__c, 1070419
selling_co_office_mls_id__c, COMP12
selling_co_office_name__c, Compass
selling_co_office_number__c, 28739
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2906
size__c, 2906
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 4th
subdist__c, Lake Street
ffd_name, 172 4th 174 Avenue, San Francisco, CA, 94118
website_property_type__c, Duplex
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1920
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530365332-1.jpg
ListingId, a0E8W00000V1y2CUAR