meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212309' 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, 170 Valley Street, San Francisco, CA, 94131
ffd_mls_id, 498399
ffd_salesforce_id, a0E1I00000SKcfGUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 170 Valley Street, San Francisco, CA, 94131
pba__address_pb__c, 170 Valley Street, San Francisco, CA, 94131
agent_only_remarks__c, By appointment only after PEAD & Preapproval are submitted and buyer has reviewed all virtual media: www.ValleyStreetDream.com. Appointments will be confirmed only after required documents are submitted PLEASE NOTE: The seller has NOT verified that the property has been properly disinfected and is NOT providing personal protective equipment at the property to protect against exposure to COVID-19. Any party who enters the home must provide their own appropriate protective items and must enter at their own risk. Buyers should investigate to their satisfaction.
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-06-26
ffd_createddate, 2020-06-16T21:45:47.000+0000
days_on_market__c, 1128
dom__c, 10
ffd_description_pb, Special Noe Valley home reno'd to studs in 2014 as the owners' primary residence. 4BDRs/4BAs, a study/fifth BDR, and a home office/playroom. 3BDRs & 2BAs upstairs - the coveted family layout. Great room w soaring ceilings, 14ft marble island w/ seating for six, Viking range, spacious dining rm for large dinner parties, and living rm area with massive fireplace. This room, lined with custom windows and sliding glass doors, flows right onto a deck and expansive, private, resort-like garden. Stunning master suite with built in shelving, WIC, en suite BA w soaking tub. Wide plank oak floors through out. All new systems (2015), electrical, and structural upgrades. Wired for ethernet. Nest thermostats w dual-zone heating. Built in speakers. Access to full lvl of attic space for storage/future expansion. Huge garage w/ expansion potential. 97 WalkScore & 96 BikeScore - Walk to the J-Church, 30th & Church retail hub, the 24th street village. This 1 of a kind home won't come around again!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-25T15:22:54.000+0000
pba__latitude_pb__c, 37.74478
pba__latitude_property__c, 37.74478
listed_date__c, 2020-05-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jessica
pba__listing_agent_lastname__c, Branson
listing_agent_mls_id__c, 805610
ffd_listingagentname, Jessica Branson
listing_agent_number__c, 166015601
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 3295000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=Nvfi7Shhc1T&mls=1
pba__longitude_pb__c, -122.42607
pba__lotsize_pb__c, 0.07
mls_id__c, 498399
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-06-16
original_price__c, 3295000
overall_days_on_market__c, 84
parking__c, Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-06-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1532.26
pba__propertytype__c, Single Family Residence
id, a0E1I00000SKcfGUAT
sale_date__c, 2020-07-28
sale_price__c, 3800000
selling_agent_mls_id__c, 089336
selling_agent_name__c, Patty Rogers
selling_agent_number__c, 89336
selling_co_agent_mls_id__c, 812378
selling_co_agent_name__c, Stephen Bartlett
selling_co_agent_number__c, 1056316
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2480
size__c, 2480
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Valley
subdist__c, Noe Valley
ffd_name, 170 Valley Street, San Francisco, CA, 94131
transportation__c, 1 Block
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363327-1.jpg
ListingId, a0E1I00000SKcfGUAT