meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='374210' 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-11-11 10:53:21
[post_modified_gmt] => 2024-11-11 18:53:21
[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, 1735680914
ffd_listing_title, 1699 Valencia Street #306, San Francisco, CA, 94110
ffd_mls_id, 423924359
ffd_salesforce_id, a0EUd0000017uGFMAY
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 20
address2__c, 1699 Valencia Street #306, San Francisco, CA, 94110
pba__address_pb__c, 1699 Valencia Street #306, San Francisco, CA, 94110
agent_only_remarks__c, Broker's Tour on 2/27: Due to an emergency, I'm not able to host. Here are access instructions: Enter via the Hoa door at 3184 Mission. Dial on the call box for Blakely scroll all the way down. Go up the elevator to 3rd floor. Go to unit 306. Just past the unit on the right (the last door) is the door to the common stair -- key box is there; Code is 3698. Please note: there was a leak in the commercial unit on the street level, which impacted the lobby. Everything is under repairs now but pardon the temporary mess. The parking spot in the garage is 16. There is also a locked bike storage area on the ground level. Contact Blakely for offer date and information. This is a fabulous deal...I sold unit 406 (same floorplan, just 1 floor up) in 2020 for $1,401,000!! More info: 415-410-3455; [email protected]. Property website: www.brightandopencondo.com Disclosure link: https://app.disclosures.io/link/1699-Valencia-St-306-baq68yif
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Oven;Free Standing Refrigerator;Self/Cont Clean Oven;Gas Cook Top
architectural_style__c, Contemporary;Modern/High Tech
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2006
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-02-14T17:46:57.000+0000
days_on_market__c, 321
dom__c, 15
ffd_description_pb, Welcome to this luxurious 2 bed, 2 bath residence (with parking), conveniently located at the crossroads of the vibrant Bernal Heights, Noe Valley, and Mission neighborhoods. Whether you're looking to stroll the Noe Valley weekend Farmer's Market, visit a local brewery in Bernal, or enjoy some of the city's best dining in the Mission, everything you could ever want is right at your fingertips. But, when you're not exploring all that the area has to offer, you'll enjoy an abundance of natural light, city views, and a desirable open floor plan in your unit that will make all of your friends envious. The two spacious bedrooms offer plenty of room for your guests, family, and working from home. And, the large, modern kitchen is equipped with high end appliances and is a true chef's delight. Stylish bathrooms with contemporary fixtures add a touch of luxury to this private oasis in the city. This home is an invitation to experience the epitome of San Francisco living. Don't miss the chance to make this condo your own!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
hoa_fee_includes__c, Electricity,Homeowners Insurance,Maintenance Grounds,Trash,Water
pba__hoafees__c, 430
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-03-16T10:46:59.000+0000
pba__latitude_pb__c, 37.746024
pba__latitude_property__c, 37.746024
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-11-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Blakely
pba__listing_agent_lastname__c, Hull
listing_agent_mls_id__c, 814039
ffd_listingagentname, Blakely Hull
listing_agent_number__c, 1064166
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, AVNU
listing_office_name__c, Avenue 8 Inc.
listing_office_number__c, 28244
pba__listingprice_pb__c, 1049000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.brightandopencondo.com/
pba__longitude_pb__c, -122.419869
lower_level__c, Bedroom(s),Dining Room,Family Room,Full Bath(s),Kitchen,Living Room,Primary Bedroom
mls_id__c, 423924359
master_bathroom_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Low-Flow Toilet(s);Double Sinks;Tile
master_property__c, a0O1I000009s3OmUAI
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-02-14
original_price__c, 1049000
overall_days_on_market__c, -81858
parking_access__c, Independent
parking_features__c, Assigned,Attached,Covered,Enclosed,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-02-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-03-15T14:02:07.000+0000
price_per_square_foot__c, 879.44
pba__propertytype__c, Condominium
ListingId, a0EUd0000017uGFMAY
sale_date__c, 2024-03-15
sale_price__c, 1065000
selling_agent_mls_id__c, 808878
selling_agent_number__c, 1038181
selling_co_agent_mls_id__c, 800407
selling_co_agent_number__c, 800407
selling_co_office_mls_id__c, CBLUXURY
selling_co_office_name__c, Coldwell Banker Realty
selling_co_office_number__c, 2128
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1211
size__c, 1211
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Valencia
subdist__c, Bernal Heights
ffd_name, 1699 Valencia Street #306, San Francisco, CA, 94110
view__c, San Francisco;Twin Peaks
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2006
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530708049-1.jpg