meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331709' 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] => 2022-12-05 06:31:31
[post_modified_gmt] => 2022-12-05 14:31:31
[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, 26 St Marys Avenue, San Francisco, CA, 94112
ffd_mls_id, 423733857
ffd_salesforce_id, a0E8W00000bcr4dUAA
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 26 St Marys Avenue, San Francisco, CA, 94112
pba__address_pb__c, 26 St Marys Avenue, San Francisco, CA, 94112
agent_only_remarks__c, The tax records are off. The room count is 5 not 4. The floor plan footage shows approximately 1000sq feet. Feel free to verify sq feet as well as any other material facts. It will be greatly appreciated if Escrow stays with Mary Ann Bunnel of Doma. Disclosures copy paste on your browser: https://app.disclosures.io/link/26-Saint-Marys-Avenue-ify9rl3v For showings give a call - super easy to show. Due to sellers traveling and spotty internet connection the Offer Due Date is 06/14 Wednesday @12:00PM.
bath_features__c, Tub w/Shower Over;Low-Flow Shower(s);Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1904
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-05-16T10:49:50.000+0000
days_on_market__c, 25
dom__c, 25
ffd_description_pb, Nestled between Glen Park & Bernal Heights, 26 St. Marys offers you the best of both neighborhoods. Historically this was the original site of Saint Marys College, these homes were built for the teaching staff. This neighborhood is perfectly located. Commuters will love the proximity to 101, 280, Glen Park BART, Muni & tech-shuttle stops, while dog lovers will appreciate the short walk to Holly Park. The sun-drenched backyard is secured from the wind, complete with a walk-out deck, seating and barbecue area, is perfect for the urban gardener or outdoor entertainer. The chef in the family will be right at home in the remodeled kitchen with stainless steel appliances, granite countertops and generous cabinet space. With beautiful hardwood floors, moldings, plantation shutters and decorative fireplace, 26 Saint Marys is an amazing mix of historic character and the conveniences of today, because yesss wait for it ... it has central air-conditioning. Due to sellers traveling out of the country offers are due 6/14.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-06-09T10:49:03.000+0000
pba__latitude_pb__c, 37.73427
pba__latitude_property__c, 37.73427
laundry_features__c, In Basement;Washer Included;Dryer Included
listed_date__c, 2023-04-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Loukia
pba__listing_agent_lastname__c, Karneris
listing_agent_mls_id__c, 809129
ffd_listingagentname, Loukia Karneris
listing_agent_number__c, 1040530
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, HARPER
listing_office_name__c, Harper Real Estate
listing_office_number__c, 27612
pba__listingprice_pb__c, 1199000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.zillow.com/view-imx/8fab1625-5488-412e-9638-01f5ee444e08?initialViewType=pano&utm_source=dashboard
pba__longitude_pb__c, -122.4264783
lower_level__c, Garage,Retreat,Street Entrance
mls_id__c, 423733857
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Low-Flow Shower(s);Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-05-15
open_house_end__c, 2023-06-10T17:00:00.000+0000
open_house_start__c, 2023-06-10T14:00:00.000+0000
original_price__c, 1199000
overall_days_on_market__c, -81583
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 1800-01-01
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
ListingId, a0E8W00000bcr4dUAA
road_surface_type__c, Asphalt
room_type__c, Bonus Room;Kitchen;Living Room;Dining Room
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, St Marys
subdist__c, Bernal Heights
ffd_name, 26 St Marys Avenue, San Francisco, CA, 94112
view__c, City
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Coverings
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530603262-1.jpg