meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209970' 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-03-19 14:18:08
[post_modified_gmt] => 2024-03-19 21:18:08
[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, 3737 Folsom Street, San Francisco, CA, 94110
ffd_mls_id, 490604
ffd_salesforce_id, a0E1I00000QpalBUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 3737 Folsom Street, San Francisco, CA, 94110
pba__address_pb__c, 3737 Folsom Street, San Francisco, CA, 94110
agent_only_remarks__c, Trust Sale, AS-IS OFFERS due Tuesday,Feb 18 @ 12noon. Last showing of in-law unit, Tuesday,Feb 18 @ 10am. Text Mary at 650-996-3606 to make appt. Please Follow Offer Instr in disc pkg Email offers to: [email protected] [email protected] House is VACANT Supra on for house,garage and yard 9am-8pm. TENANT occupies in-law only Rent $1000/mo.in-law Please Do not disturb. Subject to tenants rights. DISCLOSURES at www.vphouses.com, click office listings, click small white icon for disc Jane 650-619-6569 or Mary 650-996-3606
appliances__c, Gas Water Heater;Electric Range;Freestanding Range
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1955
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mary Paolini
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-02-03T16:45:31.000+0000
days_on_market__c, 1262
dom__c, 15
ffd_description_pb, Highly Desirable Bernal Heights Location! Lovely 2 Bedroom, 1 Bath home w/ beautiful period moldings and a fabulous view! Gated Entry, Open air vestibule with Terrazzo stairs.Separate entry hall.Light filled Living Room has hardwood flrs, fireplace w/decorative mantel & moldings. Large eat in kitchen with beautiful expansive view, opens on to small deck. Hall Bath with separate shower and tub.2 Spacious Bedrooms with generous closet space and hardwood floors.1 car parking with laundry area, additional storage area below garage. Fenced in rear yard. Just steps away to coveted Cortland Avenue-enjoy the quaint shops and restaurants. Walk to Mission street, close-in to Noe Valley & Glen Park. Ideally located to Muni, Bart, 280 and 101.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Linoleum;Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-12T15:27:19.000+0000
pba__latitude_pb__c, 37.73978
pba__latitude_property__c, 37.73978
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2019-12-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jane
pba__listing_agent_lastname__c, Venturi
listing_agent_mls_id__c, 807428
ffd_listingagentname, Jane E Venturi
listing_agent_number__c, 1034683
listing_co_agent_mls_id__c, MLSL167821
listing_co_agent_number__c, 981195288
listing_co_office_mls_id__c, VNP-1
listing_co_office_name__c, Venturi & Paolini Real Estate
listing_co_office_number__c, 981050137
listing_office_mls_id__c, VPRE
listing_office_name__c, Venturi & Paolini Real Estate
listing_office_number__c, 24042
pba__listingprice_pb__c, 1049000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.41316
pba__lotsize_pb__c, 0.04
mls_id__c, 490604
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-02-03
original_price__c, 1500000
overall_days_on_market__c, 38
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Interior Access,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-02-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 924.78
pba__propertytype__c, Single Family Residence
id, a0E1I00000QpalBUAR
room_type__c, Storage;In Law Apartment
sale_date__c, 2020-03-09
sale_price__c, 1500000
security_features__c, Smoke Detector;Security Gate
selling_agent_mls_id__c, 809119
selling_agent_name__c, Judson B. Gregory
selling_agent_number__c, 1040495
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, 1622
size__c, 1622
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Folsom
subdist__c, Bernal Heights
ffd_name, 3737 Folsom Street, San Francisco, CA, 94110
transportation__c, 1 Block
view__c, City Lights;Water
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1955
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/359855-1.jpg
ListingId, a0E1I00000QpalBUAR