meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212275' 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, 1907 Diamond Street, San Francisco, CA, 94131
ffd_mls_id, 498009
ffd_salesforce_id, a0E1I00000SlhFOUAZ
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 1907 Diamond Street, San Francisco, CA, 94131
pba__address_pb__c, 1907 Diamond Street, San Francisco, CA, 94131
agent_only_remarks__c, Call or text Wendy @ 415.519.6091 for additional details or email [email protected]. Agents / Visitors must complete CAR PEAD and Sotheby's COVID-19 Forms and receive the CAR Guidelines. Docs are attached to the listing. Take Virtual Tour at Link above or https://vimeo.com/419266782. Visit www.1960sJetAgeSwank.com
appliances__c, Dishwasher;Microwave;Disposal;Refrigerator;Hood Over Range;ENERGY STAR Qualified Appliances;Cooktop Stove;Double Oven;Ice Maker
architectural_style__c, Contemporary;Modern/High Tech;Craftsman
bath_features__c, Tub w/Shower Over;Shower Stall(s);Remodeled
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1967
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-05-22
ffd_createddate, 2020-05-16T02:45:56.000+0000
days_on_market__c, 1160
dom__c, 28
ffd_description_pb, Powerful expression of 1960's California architectural ideas, custom home w/ Jet-Age credentials conceived as ultimate in residential swank. Built in 67 for builder's family, now polished & restored, sits on spectacular site w/ stunning views East. Surrounded by tall trees & powerful hills, muscular design tied to bedrock & triple-engineered, robust build. Reverence to CA nature abound: wide plank oak flooring, lava rock FP, high ceilings, open simple floorplan, emulate stand of redwoods surrounded by conifers, eucalyptus, foot paths. Wide lot, entry sculpture garden welcome visitors to airy vaulted ceilings, opens to massive deck w/ dazzling city & views. Pro kitchen w/ efficient layout, floor to ceiling cabinets, & casual dining projected into views. 3 BDs on main level w/ master suite. Below are family room, guest suite w/ separate entrance, laundry, storage + view deck. 2 car SxS parking, storage in garage. Proximate to green spaces, Noe & Glen Park villages. EZ commute South.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter;Stone;Raised Hearth
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:22:44.000+0000
pba__latitude_pb__c, 37.74235
pba__latitude_property__c, 37.74235
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-03-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Wendy
pba__listing_agent_lastname__c, Storch
listing_agent_mls_id__c, 803139
ffd_listingagentname, Wendy M Storch
listing_agent_number__c, 803139
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 3295000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/419266782
pba__longitude_pb__c, -122.43521
pba__lotsize_pb__c, 0.09
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 498009
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-05-15
original_price__c, 3295000
overall_days_on_market__c, 46
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-06-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1155.96
pba__propertytype__c, Single Family Residence
id, a0E1I00000SlhFOUAZ
roof__c, Tar/Gravel
room_type__c, Storage;Laundry;In Law Apartment
sale_date__c, 2020-06-22
sale_price__c, 3150000
selling_agent_mls_id__c, 811041
selling_agent_name__c, Winnie Lai
selling_agent_number__c, 1049417
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 2725
size__c, 2725
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Diamond
subdist__c, Noe Valley
ffd_name, 1907 Diamond Street, San Francisco, CA, 94131
transportation__c, 1 Block
view__c, Panoramic;City Lights;Garden/Greenbelt;Bay;Water;Downtown;Bay Bridge;San Francisco;Hills;Mountains;Woods;Canyon;Mt Diablo;Forest
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1967
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363242-1.jpg
ListingId, a0E1I00000SlhFOUAZ