meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214251' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15733
[post_author] => 4
[post_date] => 2018-11-02 19:54:58
[post_date_gmt] => 2018-11-02 19:54:58
[post_content] => Sunny, sedate, central, strollers, and tech-centric. Once upon a time home searches began in Pacific Heights and settled for Noe Valley. Now home searches begin here and settle for Pacific Heights.
Connect with a Jackson Fuller Real Estate agent today and explore the diverse range of homes for sale in Noe Valley.
[post_title] => Noe Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => noe-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-07 13:06:57
[post_modified_gmt] => 2024-03-07 21:06:57
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15733
[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, 290 San Jose Avenue, San Francisco, CA, 94110
ffd_mls_id, 503870
ffd_salesforce_id, a0E1I00000TG5kjUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 2
address2__c, 290 San Jose Avenue, San Francisco, CA, 94110
pba__address_pb__c, 290 San Jose Avenue, San Francisco, CA, 94110
agent_only_remarks__c, COVID-compliant showings by appointment only at https://calendly.com/290sanjose/30-mintour?month=2020-08 Please send PEAD-V form to [email protected]. Disclosures via IO link above. Window treatments included in sale. Pre-sale escrow with Elisabeth Davis at Fidelity. Contact Scott with questions (415)505-0983 text/cell or (530)478-1090 home. **More info and 3D tour at www.290SanJose.com**
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1946
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-08-28T15:46:24.000+0000
days_on_market__c, 1055
dom__c, 26
ffd_description_pb, Located in that *sweet spot* where Noe Valley greets the Mission, this stylish, urban flat perfectly blends relaxed comfort with contemporary convenience. Smart layout and open flow from living room to dining room to kitchen. Modern chef's kitchen with stainless Viking & Thermador appliances, high-end finishes, custom cabinetry and floating shelves. Luxury bath features walk-in shower with bench seating, lovely tile work and Kohler fixtures. Two generously-sized bedrooms, one with custom Elfa storage system, look out over the back garden. Gorgeous, high-grain wood floors throughout. Take advantage of one of the city's best micro-climates while lounging in the shared, easy-to-maintain backyard retreat. On site garage parking for 1 car plus ample storage. A short stroll leads you to laidback Noe or vibrant Valencia Street. 100 Walk Score/95 Bike Score. Casually run HOA with low, low dues. Welcome to 290 San Jose!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
hoa_dues__c, 180.69
pba__hoafees__c, 180
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-25T15:31:55.000+0000
pba__latitude_pb__c, 37.750635
pba__latitude_property__c, 37.750635
listed_date__c, 2020-07-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Scott
pba__listing_agent_lastname__c, Yarmark
listing_agent_mls_id__c, 808620
ffd_listingagentname, Scott S Yarmark
listing_agent_number__c, 1037311
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CGL
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28240
pba__listingprice_pb__c, 1375000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?mls=1&m=VEday1VN2kT" frameborder="0" allowfullscreen allow="vr">
pba__longitude_pb__c, -122.421695
pba__lotsize_pb__c, 0
mls_id__c, 503870
master_property__c, a0O1I00000AdT22UAF
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-08-28
original_price__c, 1425000
overall_days_on_market__c, 86
parking_access__c, Side by Side
parking_features__c, Attached,Interior Access,Side-by-Side,Size Limited,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-09-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1237.62
pba__propertytype__c, Condominium
id, a0E1I00000TG5kjUAD
sale_date__c, 2020-10-23
sale_price__c, 1375000
selling_agent_mls_id__c, 803117
selling_agent_name__c, Danielle H. Lazier
selling_agent_number__c, 803117
selling_co_agent_mls_id__c, 809927
selling_co_agent_name__c, Joshua Ortiz
selling_co_agent_number__c, 1044191
selling_co_office_mls_id__c, COMP2
selling_co_office_name__c, Compass
selling_co_office_number__c, 27341
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1111
size__c, 1111
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, San Jose
subdist__c, Noe Valley
ffd_name, 290 San Jose Avenue, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1946
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/368774-1.jpg
ListingId, a0E1I00000TG5kjUAD