meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='415737' 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
(
)
)
_yoast_indexnow_last_ping, 1727909602
ffd_listing_title, 125 Highland Avenue, San Francisco, CA, 94110
ffd_mls_id, 424065174
ffd_salesforce_id, a0EUd0000039AjDMAU
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 4
address2__c, 125 Highland Avenue, San Francisco, CA, 94110
pba__address_pb__c, 125 Highland Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Go direct, on Supra LB. Text/call listing agent Marcus Miller 415.516.5760 4 showings. Most affordable 3BR condo in Bernal/INR Mission right now. Move-in ready, great light, updated. Show & sell. Disclosure available upon request. Pre-escrow #0062400341-MG with Fidelity National Title Co. Michael Gaffney, 415.346.5012 | [email protected] Sellers reserve the right to accept, counter or reject any offer.
appliances__c, Hood Over Range;Tankless Water Heater;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Electric Water Heater;Free Standing Electric Range
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over;Shower Stall(s);Low-Flow Toilet(s);Dual Flush Toilet;Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1906
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-19T10:48:36.000+0000
days_on_market__c, 13
dom__c, 13
ffd_description_pb, Welcome to 125 Highland Avenue, a lovely top-floor 3-bedroom condominium located in the heart of San Francisco's highly desirable Bernal Heights neighborhood. Blending charm and modern amenities, this home offers a great location just one block from Holly Park and minutes from vibrant cafes and shops. Step into the formal entryway, where timeless period details greet you, including an original ceiling medallion, dramatic columns, 10-foot ceilings, and beautifully refinished parquet floors. The sunlit living room, adjacent to the updated eat-in kitchen, boasts large south-facing windows, creating an inviting space to relax. Updated in 2024, the kitchen features sleek quartz countertops and new stainless steel appliances. Two bedrooms at the front of the home offer comfort and style, while the third bedroom doubles as a spacious home office. The updated bathroom includes a vanity and shower over tub. Additional features include one-car secure parking and a prime location with a 91 walk score, giving you easy access to the Cortland corridor with boutique shops, cafes and restaurants, Holly Park Circle, and convenient freeway access to 101 and 280. A great home for the sophisticated urban dweller.
district__c, SF District 9
driveway_sidewalks__c, Gated,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Metal
pba__floortype_pb__c, Tile;Wood;Parquet
hoa_fee_includes__c, Common Areas,Insurance on Structure,Maintenance Exterior,Maintenance Grounds
pba__hoafees__c, 317
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Highland HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2024-10-02T22:49:28.000+0000
pba__latitude_pb__c, 37.7375846
pba__latitude_property__c, 37.7375846
listed_date__c, 2024-08-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marcus
pba__listing_agent_lastname__c, Miller
listing_agent_mls_id__c, 803019
ffd_listingagentname, Marcus Miller
listing_agent_number__c, 803019
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, HELM
listing_office_name__c, Helm Real Estate
listing_office_number__c, 27303
pba__listingprice_pb__c, 979000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.423253
mls_id__c, 424065174
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance;Primary Bedroom
master_property__c, a0OUd00000CEfqrMAD
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-19
open_house_end__c, 2024-10-02T18:00:00.000+0000
open_house_start__c, 2024-10-02T16:00:00.000+0000
original_price__c, 979000
overall_days_on_market__c, -82076
parking_access__c, Side by Side
parking_features__c, Uncovered Parking Space
parking_type__c, On Site - Assigned (Condo Only)
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, 920.11
pba__propertytype__c, Condominium
ListingId, a0EUd0000039AjDMAU
road_surface_type__c, Asphalt,Paved
room_type__c, Kitchen;Living 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, 1064
size__c, 1064
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Highland
subdist__c, Bernal Heights
ffd_name, 125 Highland Avenue, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530842072-1.jpg
