meta_query='key:subdist__c;value:Central Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215052' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70208
[post_author] => 4
[post_date] => 2018-11-30 20:29:21
[post_date_gmt] => 2018-11-30 20:29:21
[post_content] => What used to be rolling sand dunes as far as the eye can see is now an orderly neighborhood of tidy homes. Views of the Golden Gate Bridge are a welcome surprise from the lucky parts. Proximity to the park appeals to those with canines and kids.
[post_title] => Central Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:27:28
[post_modified_gmt] => 2024-04-09 17:27:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70208
[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, 800 27th Avenue, San Francisco, CA, 94121
ffd_mls_id, 506861
ffd_salesforce_id, a0E1I00000THoEVUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 800 27th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 800 27th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, Please email [email protected] and cc [email protected] for disclosures. Pre-escrow with Elisabeth Davis at Fidelity National Title Escrow No. 0312000117. Lower floor room on the right is labeled as an entertainment room in approved plans and signed permits. Studio on the left of garage is a legal studio and legal kitchen. Back on market due to no fault of property. Buyer was unable to get financing. Please contact Janice for offer instructions.
appliances__c, Dishwasher;Gas Range;Refrigerator;Freestanding Range;Hood Over Range;ENERGY STAR Qualified Appliances
architectural_style__c, Spanish/Med
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Remodeled;Tile
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1935
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-25T10:46:34.000+0000
days_on_market__c, 1028
dom__c, 53
ffd_description_pb, Back on market due to no fault of property. Buyer could not get financing. Newly renovated 5BD/4BA corner Spanish Mediterranean home in Central Richmond. Bright open contemporary kitchen features modern cabinetry, quartz counters, large skylight, under cabinet lighting & stainless steel appliances. Designer bathrooms w/ Grohe fixtures. Stylish design and finishes complete with refinished hardwood floors, LED recessed lighting and skylights. Fresh interior and exterior paint. A highly desirable layout consists of 3BD/2BA on the main floor with a formal living room w/ wood burning fireplace. Lower level with legal spacious studio perfect for extended family & guests or rental income/AirBnB. An additional legal office/room & extra full bathroom complete the lower level. Rare and coveted large 2 car side by side independent parking & sunny landscaped garden. Updated copper pipes and electrical. Easy public transportation, close to Golden Gate Park, restaurants, shops & conveniences.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:35:42.000+0000
pba__latitude_pb__c, 37.7742062
pba__latitude_property__c, 37.7742062
laundry_features__c, Washer/Dryer Included;In Basement
listed_date__c, 2020-09-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Janice
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 805814
ffd_listingagentname, Janice Lee
listing_agent_number__c, 166015866
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COLD02
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 874
pba__listingprice_pb__c, 1895000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=EQjg8J4NHvY&mls=1
pba__longitude_pb__c, -122.486212
pba__lotsize_pb__c, 0.06
lower_level__c, Kitchen,Master Bedroom
mls_id__c, 506861
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-09-24
original_price__c, 1895000
overall_days_on_market__c, 98
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-11-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E1I00000THoEVUA1
room_type__c, Den;Studio
sale_date__c, 2020-12-17
sale_price__c, 2000000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 803029
selling_agent_name__c, Jennifer Rosdail
selling_agent_number__c, 803029
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Keller Williams San Francisco
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 27th
subdist__c, Central Richmond
ffd_name, 800 27th Avenue, San Francisco, CA, 94121
transportation__c, 1 Block
view__c, San Francisco
website_property_type__c, Single Family Home
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 1935
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371007-1.jpg
ListingId, a0E1I00000THoEVUA1