meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209929' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15717
[post_author] => 4
[post_date] => 2018-11-02 19:54:32
[post_date_gmt] => 2018-11-02 19:54:32
[post_content] => Once a San Francisco skunkworks flying pirate flags filled with humble Victorian cottages owned by ladies who loved ladies and looked forward to long dog walks. Then it gentrified. Silicon Valley stock options splurged on homes here. Dwell magazine arrived next to document the results. While it might be one Bernal, the neighborhood has several distinct geographic vibes and styles. It's not complicated, perhaps recently algorithmically optimized?
[post_title] => Bernal Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bernal-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 08:39:15
[post_modified_gmt] => 2024-04-11 15:39:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15717
[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, 738 Gates Street, San Francisco, CA, 94110
ffd_mls_id, 493700
ffd_salesforce_id, a0E1I00000Qp2EgUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 738 Gates Street, San Francisco, CA, 94110
pba__address_pb__c, 738 Gates Street, San Francisco, CA, 94110
agent_only_remarks__c, Under contract, please no more showings. Contact [email protected]. Questions Text Bud at 408-710-4205. Pre-escrow open with Amy Freitas at Old Republic Title
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Hood Over Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Remodeled;Tile;Dual Flush Toilet;Granite
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1965
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-01-30T19:46:18.000+0000
days_on_market__c, 1266
dom__c, 12
ffd_description_pb, Stunning Fully Renovated Bernal Heights Home! This single family home has been thoughtfully renovated to fit modern day needs, turnkey ready for the next few generations! Open space concept, modern kitchen, new cabinetry, max storage, quartz counter tops, stainless appliances, dining area, 3 Bedrooms, and 3 full bathrooms. All new windows, electrical, plumbing, recessed overhead LED lighting throughout , Furnace, Tankless hot water heater, patio, fences, decking and roof. Easy access to newly renovated entertainment ready backyard through master bedroom and family room. Keyless entry, Smart lighting, Nest, Internet/Cable ready. Easy 101 and 280 freeway access. Grab a coffee at Progressive Grounds, have pizza night at Vega, or pickup sweet and savory treats at Little Bee Baking. The SF urban lifestyle perfected! This is not a must see, this is a must have!!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Tile;Simulated Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-12T15:27:11.000+0000
pba__latitude_pb__c, 37.734042
pba__latitude_property__c, 37.734042
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2020-01-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Harold
pba__listing_agent_lastname__c, Meacham
listing_agent_mls_id__c, 810241
ffd_listingagentname, Bud Meacham
listing_agent_number__c, 1045141
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, DECOR1
listing_office_name__c, Renovation Realty
listing_office_number__c, 25679
pba__listingprice_pb__c, 1249000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.414569
pba__lotsize_pb__c, 0.04
mls_id__c, 493700
main_level__c, Full Bath(s);Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-01-30
original_price__c, 1249000
overall_days_on_market__c, 340
parking__c, Attached,Garage
parking_access__c, Side by Side
parking_features__c, Attached,Side-by-Side,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-02-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1115.7
pba__propertytype__c, Single Family Residence
id, a0E1I00000Qp2EgUAJ
roof__c, Bitumen
room_type__c, Storage;Den
sale_date__c, 2020-03-09
sale_price__c, 1350000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 666666
selling_agent_name__c, Non Member Sales
selling_agent_number__c, 666666
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, 1210
size__c, 1210
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Gates
subdist__c, Bernal Heights
ffd_name, 738 Gates Street, San Francisco, CA, 94110
website_property_type__c, Single Family Home
window_features__c, Dual Pane;Window Screens
pba__yearbuilt_pb__c, 1965
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/359746-1.jpg
ListingId, a0E1I00000Qp2EgUAJ