meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211298' 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, 40 Lundys Lane, San Francisco, CA, 94110
ffd_mls_id, 421542166
ffd_salesforce_id, a0E1I00000USEy0UAH
num_of_rooms__c, 8
of_units__c, 2
address2__c, 40 Lundys Lane, San Francisco, CA, 94110
pba__address_pb__c, 40 Lundys Lane, San Francisco, CA, 94110
agent_only_remarks__c, Upper unit is tenant occupied. Tenant works from home, please do not disturb. Please show lower unit and full basement with high ceilings on lockbox by appointment on Showing Time. See upper unit on video, in photos & 3D showcase. Tenant is protected by age. Email for disclosures [email protected]. Offers due Wednesday 5/5/2021 @ 1:30pm.
appliances__c, Dishwasher;Gas Water Heater;Built-In Gas Range;Free Standing Gas Range;Free Standing Refrigerator;Varies By Unit
architectural_style__c, Barn Type
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-05-06
cooling__c, None
ffd_createddate, 2021-04-25T18:46:18.000+0000
days_on_market__c, 816
dom__c, 14
ffd_description_pb, Located on a tranquil cul-de-sac yet close to all the Bernal action, this charming 2-unit building offers cozy living & beautiful views of Twin Peaks and Downtown. The front garden creates privacy for the vacant lower unit which has vintage dcor with high ceilings, hardwood floors, crown moldings & classic trim. The Bay window in the grand living room is perfect for gazing at the views in the afternoon sun. The spacious kitchen with tile floor opens to a sunny dining room with a skylight & large windows the better to see those views! The 2 bedrooms adjoin at the front of the unit & the updated bath is around the corner. The 1 bedroom unit upstairs has a large living space with a sliding glass door to a deck & even better views! The eat-in kitchen gets lots of sun & the spacious bedroom looks over the front garden and the charming street. Down the back staircase is the terraced yard & the full basement (expansion potential?) with laundry & lots of storage. Newly painted inside & out!
district__c, SF District 9
exterior_features__c, Fenced Yard;Play Area
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Wall Furnace;Varies by Unit
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2022-01-25T13:33:38.000+0000
pba__latitude_pb__c, 37.744671
pba__latitude_property__c, 37.744671
laundry_features__c, Washer/Dryer Owned
listed_date__c, 2021-02-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Deborah
pba__listing_agent_lastname__c, Lopez
listing_agent_mls_id__c, 369112
ffd_listingagentname, Deborah Lopez
listing_agent_number__c, 369112
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 1150000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=s9iZHwBobQF&mls=1
pba__longitude_pb__c, -122.41857
mls_id__c, 421542166
master_property__c, a0O8W00000DaFBNUA3
parkingspaces__c, 0
on_market_date__c, 2021-04-24
original_price__c, 1150000
overall_days_on_market__c, 98
patio_and_porch_features__c, Uncovered Patio;Balcony/Deck;Varies by Unit
pba__pendingdate__c, 2021-05-08
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 917.27
pba__propertytype__c, Duplex
id, a0E1I00000USEy0UAH
roof__c, Composition
sale_date__c, 2021-06-04
sale_price__c, 1275000
security_features__c, Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 398474
selling_agent_number__c, 398474
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1390
size__c, 1390
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Lundys
subdist__c, Bernal Heights
ffd_name, 40 Lundys Lane, San Francisco, CA, 94110
view__c, City;Panoramic;City Lights;Downtown;San Francisco;Twin Peaks;Ridge
website_property_type__c, Duplex
window_features__c, Bay Window(s);Varies by Unit
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530225952-1.jpg
ListingId, a0E1I00000USEy0UAH