meta_query='key:subdist__c;value:Inner Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216290' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12162
[post_author] => 4
[post_date] => 2018-10-29 01:21:18
[post_date_gmt] => 2018-10-29 01:21:18
[post_content] => Barely west of Laurel Village and Jordan Park. Very east of Ocean Beach. It's not a transitional neighborhood, it's the Inner Richmond. Delightful shops on Clement Street and a surprisingly central location. But no Muni light rail.
[post_title] => Inner Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => inner-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-04 08:18:28
[post_modified_gmt] => 2024-11-04 16:18:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12162
[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, 627 4th Avenue, San Francisco, CA, 94118
ffd_mls_id, 511224
ffd_salesforce_id, a0E1I00000TvPyiUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 11
of_units__c, 0
address2__c, 627 4th Avenue, San Francisco, CA, 94118
pba__address_pb__c, 627 4th Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Offers due at 12 noon on Monday, 1/18. Check windows of time to make a private showing appointment. Home is staged. Fully renovated with the benefits of permits. According to tax records, 3051 square feet; per architecture plan, 3416 square feet. For all COVID-compliant showing inquiries, please email Chris at [email protected] Showings subject to COVID-19 SIP guidelines. Property website, Matterport, floorpan, video, and disclosures available. Pre-escrow opened with Kristin Therre at Old Republic. Please submit any offers on 7-page SFAR contact with POF/lender approval letter and forthcoming signed disclosures.
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Freestanding Range;Hood Over Range;Cooktop Stove;Ice Maker;Freezer
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1906
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-01-11T11:46:27.000+0000
days_on_market__c, 1450
dom__c, 7
ffd_description_pb, Coveted Inner Richmond single family home. This renovated 4 bedroom, 3.5 bath designer home w/deep west-facing backyard. Exceptional open-concept layout w/high ceilings and original period details. Gracious Living Room, Dining Room, chef's gas Kitchen w/stainless gas range w/hood, refrigerator, D/W, custom painted shaker cabinetry. Main Bedroom w/two closets, separate Office Alcove, huge Bathroom w/spa-like tub, dual vanities, shower, toilet room. Large 2nd Bedroom and 3rd Bedroom on the same floor. Unique Under The Sea bathroom. Separate garage entrance to lower level perfect for multi-generational families w/Family Room, bedroom, full bathroom. Garage for 1 car parking includes wine cellar, W/D w/sink in laundry room. Fully landscaped by Janet Moyer. Upgrades include closet organizers, recessed lighting, parking, ample storage, solid h/w floors, designer light fixtures. New interior and exterior paint. Desirable A+ location close to charming local retail, Safeway, GGP.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-01-25T15:41:21.000+0000
pba__latitude_pb__c, 37.776761
pba__latitude_property__c, 37.776761
laundry_features__c, In Garage;Inside Room;Washer/Dryer Included
listed_date__c, 2020-12-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Christopher
pba__listing_agent_lastname__c, Lim
listing_agent_mls_id__c, 803894
ffd_listingagentname, Chris Lim
listing_agent_number__c, 166013250
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__listing_website__c, https://cbhometour.com/627-4th-Avenue-San-Francisco-CA-94118/index.html
pba__longitude_pb__c, -122.462156
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 511224
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2021-01-11
original_price__c, 2950000
overall_days_on_market__c, 79
parking__c, Garage,Interior Access,Guest Space(s)
parking_features__c, Guest Parking Available,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-01-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1031.91
pba__propertytype__c, Single Family Residence
id, a0E1I00000TvPyiUAF
room_type__c, Storage;Laundry;Wine Cellar
sale_date__c, 2021-02-08
sale_price__c, 3525000
selling_agent_mls_id__c, 803729
selling_agent_number__c, 803729
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, 3416
size__c, 3416
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 4th
subdist__c, Inner Richmond
ffd_name, 627 4th Avenue, San Francisco, CA, 94118
transportation__c, 1 Block
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/374893-1.jpg
ListingId, a0E1I00000TvPyiUAF
_yoast_indexnow_last_ping, 1735663223