meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222498' 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, 28 Virginia Avenue, San Francisco, CA, 94110
ffd_mls_id, 422622894
ffd_salesforce_id, a0E8W00000V3CsiUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 2
address2__c, 28 Virginia Avenue, San Francisco, CA, 94110
pba__address_pb__c, 28 Virginia Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Call/Text Maddy for showings 510-846-5168. Tax records show 393 sq ft. Graphic artist measured 445 sq ft. Buyers to verify to own satisfaction. Pre-escrow opened with Amy Edberg, First American Title.
appliances__c, Dishwasher;Free Standing Gas Range;Ice Maker
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1925
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kate D Tomassi
pba__contingentdate__c, 2022-01-26
ffd_createddate, 2022-01-21T14:45:40.000+0000
days_on_market__c, 544
dom__c, 18
ffd_description_pb, Charming, light-filled, full floor condo with parking on the West slope of Bernal Heights. This 1 BD/1 BA condo has high ceilings and bay windows making for a cozy, yet spacious floor plan. It has all of the San Francisco charm with its crown molding and well maintained original hardwood floors. The bright living room features unique wood shelving and a breakfast nook that opens up into the kitchen. The remodeled kitchen features concrete countertops, stainless steel appliances, and ample cabinet space. The bedroom is spacious with bay windows, flooding it with light. Prime location nestled at the intersection of Bernal Heights, Noe Valley, and the Mission. Close to Cortland Ave, both Mission and Dolores Streets, and between Bernal Heights Park and Holly Park. A short walk to Glen Park and 24th Mission BART stations and conveniently located near MUNI lines as well as quick access to the freeway for an easy commute. Side-by-side deeded parking, storage, shared laundry, and a NEST
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 150
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Floor Furnace
ffd_lastmodifieddate, 2022-02-25T11:51:25.000+0000
pba__latitude_pb__c, 37.742809
pba__latitude_property__c, 37.742809
listed_date__c, 2022-01-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Madeline
pba__listing_agent_lastname__c, Mazzola
listing_agent_mls_id__c, 815184
ffd_listingagentname, Madeline Mazzola
listing_agent_number__c, 1071370
listing_co_agent_mls_id__c, 810756
listing_co_agent_number__c, 1047830
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 649000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.28virginia.com/
pba__longitude_pb__c, -122.42101
mls_id__c, 422622894
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000004VYgVUAW
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-01-21
original_price__c, 649000
overall_days_on_market__c, 181
parking_access__c, Side by Side
parking_features__c, Assigned,Attached,Covered,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2022-02-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-02-24T14:40:32.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E8W00000V3CsiUAF
room_type__c, Kitchen;Living Room;Master Bathroom;Master Bedroom
sale_date__c, 2022-02-24
sale_price__c, 660000
selling_agent_mls_id__c, EB146638
selling_agent_number__c, 981084122
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Exp Realty of California Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Virginia
subdist__c, Bernal Heights
ffd_name, 28 Virginia Avenue, San Francisco, CA, 94110
website_property_type__c, Condominium
window_features__c, Window Coverings;Bay Window(s)
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530389474-1.jpg
ListingId, a0E8W00000V3CsiUAF