meta_query='key:subdist__c;value:Outer Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222500' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12161
[post_author] => 4
[post_date] => 2018-10-29 17:16:40
[post_date_gmt] => 2018-10-29 17:16:40
[post_content] => Fog-cooled Outer Richmond beckons those who want to make a sleepier corner of the City home. The Cliff House, Sutro Baths, and Lands End are nearby iconic San Francisco landmarks. Welcome home, surfers, dog walkers, beachcombers, and lovers of Golden Gate Park.
[post_title] => Outer Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => outer-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:20:40
[post_modified_gmt] => 2024-03-19 19:20:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12161
[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, 563 34th 565 Avenue, San Francisco, CA, 94121
ffd_mls_id, 422620873
ffd_salesforce_id, a0E8W00000V2xhLUAR
num_of_rooms__c, 8
of_units__c, 2
address2__c, 563 34th 565 Avenue, San Francisco, CA, 94121
pba__address_pb__c, 563 34th 565 Avenue, San Francisco, CA, 94121
agent_only_remarks__c, Call LA 415-570-3090 for showing. Escrow opened with Chicago title Pauline #3542101997. Email question and request disclosure to [email protected] Office at both units used to be bedrooms. Seller reserves the right to accept, counter or reject any or all offer.
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Range;Wine Refrigerator;Built-In Refrigerator;Other
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 8
year_build_text__c, 1923
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Karen Lei
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2022-01-13T20:46:43.000+0000
days_on_market__c, 552
dom__c, 12
ffd_description_pb, Unparalleled, breathtaking panoramic 180-degree ocean and city views, which nestled in the desirable Richmond District. Magnificent modern Two units is approximately 5,489 sq-ft.(as per architect) consist of 4 spacious floors. The remodeled property recently completed with electrical, plumbing, heating systems, new roof, radiant floor, video security, multiple decks, laundry room, and a beautiful garden. The stunning beauty, 8BD/6BA/3 HALF-BA/2 family rooms, offers a grand living room with gas fireplace at each unit, gorgeous kitchen with a massive custom eat-in island, installed with Thermador appliances. Upstairs penthouse offers a family room with wet bar, and a master bedroom with resort-like bathroom plus walk-in closets. French door leads to the beautiful outdoor decks. Imagine waking up to stunning ocean view at dawn and then dramatic sunset at dusk. First floor offers a two-ca garage. Backyard has a magnificent, fully-landscaped garden which is perfect for relaxation.
district__c, SF District 1
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant Floor;Central
ffd_lastmodifieddate, 2022-02-25T12:50:56.000+0000
pba__latitude_pb__c, 37.7784107
pba__latitude_property__c, 37.7784107
laundry_features__c, Laundry Closet;Other;In Each Unit
listed_date__c, 2022-01-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Shu
pba__listing_agent_lastname__c, Pu
listing_agent_mls_id__c, 806281
ffd_listingagentname, Shu Pu
listing_agent_number__c, 166016663
listing_co_agent_mls_id__c, 814799
listing_co_agent_number__c, 1068325
listing_co_office_mls_id__c, CAFH
listing_co_office_name__c, Century 21 Realty Alliance Fine Homes and Estates
listing_co_office_number__c, 166014509
listing_office_mls_id__c, CAFH
listing_office_name__c, Century 21 Realty Alliance Fine Homes and Estates
listing_office_number__c, 166014509
pba__listingprice_pb__c, 3995000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/664080917
pba__longitude_pb__c, -122.49451
mls_id__c, 422620873
parkingspaces__c, 2
on_market_date__c, 2022-01-13
original_price__c, 3995000
overall_days_on_market__c, 106
parking_features__c, Attached,Garage
patio_and_porch_features__c, Balcony/Deck
pba__pendingdate__c, 2022-01-25
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 799.58
pba__propertytype__c, Duplex
id, a0E8W00000V2xhLUAR
roof__c, Tar/Gravel
sale_date__c, 2022-02-18
sale_price__c, 4388888
security_features__c, Smoke Detector;Carbon Mon Detector;Video System
selling_agent_mls_id__c, 816768
selling_agent_number__c, 1075708
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Century 21 Realty Alliance Fine Homes and Estates
pba__status__c, Closed
pba__totalarea_pb__c, 5489
size__c, 5489
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 34th
subdist__c, Outer Richmond
ffd_name, 563 34th 565 Avenue, San Francisco, CA, 94121
view__c, Ocean;Panoramic;City Lights
website_property_type__c, Duplex
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/530385864-1.jpg
ListingId, a0E8W00000V2xhLUAR