meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='425149' 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-10-31 12:21:05
[post_modified_gmt] => 2024-10-31 19:21:05
[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
(
)
)
_yoast_indexnow_last_ping, 1741519052
ffd_listing_title, 374 Valley Street, San Francisco, CA, 94110
ffd_mls_id, 425016068
ffd_salesforce_id, a0EUd000004RuVFMA0
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
pba__address_pb__c, 374 Valley Street, San Francisco, CA, 94110
address2__c, 374 Valley Street, San Francisco, CA, 94110
agent_only_remarks__c, Property is lender owned. Buyer to conduct all investigations|inspections to their satisfaction. Buyer acknowledges and agrees that Buyer is accepting the Property 'As Is,' without any warranties, representations or guarantees, either expressed or implied, of any kind, nature or type whatsoever from or on behalf of the Seller. Please call/text Anh @650.380.6364, for any questions. https://vimeo.com/982428083
appliances__c, Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Oven;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tile;Low-Flow Toilet(s);Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-03-05T22:47:41.000+0000
days_on_market__c, 4
dom__c, 4
ffd_description_pb, Nestled in the prestigious Noe Valley district, this exquisite luxury home has been meticulously reimagined to offer the epitome of modern elegance and sophistication. Boasting unparalleled craftsmanship and attention to detail, every aspect of this home has been thoughtfully designed to create a seamless blend of contemporary style and timeless beauty. Step inside and you are greeted by an expansive staircase that exudes a sense of grandeur. The soaring ceilings, abundant natural light, and carefully curated finishes create a welcoming and luxurious atmosphere. The gourmet kitchen is a chef's dream, featuring top-of-the-line Bertazzoni appliances and custom cabinetry. The adjacent dining area offers a graceful space for intimate gatherings and memorable dining experiences. The master suite is a private oasis with direct backyard access. The secondary master suite is perfect for live-in parents or au pair with some separation and privacy. Located within proximity to upscale boutiques and trendy restaurants, don't miss out on this impeccably reimagined home with the finest finishes and luxurious amenities.
district__c, SF District 5
electric__c, 220 Volts in Kitchen,220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood
pba__floortype_pb__c, Other;Tile
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, MultiZone
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2025-03-09T10:46:16.000+0000
pba__latitude_pb__c, 37.7444655
pba__latitude_property__c, 37.7444655
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2025-03-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Anh
pba__listing_agent_lastname__c, Pham
listing_agent_mls_id__c, 807249
ffd_listingagentname, Anh H Pham
listing_agent_number__c, 1012152
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SKYGR
listing_office_name__c, SkyGroup Realty Inc.
listing_office_number__c, 25039
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.430587
mls_id__c, 425016068
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Double Sinks;Tile;Low-Flow Shower(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2025-03-05
open_house_end__c, 2025-03-09T15:00:00.000+0000
open_house_start__c, 2025-03-09T13:00:00.000+0000
original_price__c, 1995000
overall_days_on_market__c, -82243
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio;Front Porch
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, 1088.97
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000004RuVFMA0
roof__c, Bitumen
room_type__c, Laundry;Kitchen;Living Room;Primary Bedroom 2+
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, 1832
size__c, 1832
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Valley
subdist__c, Noe Valley
ffd_name, 374 Valley Street, San Francisco, CA, 94110
view__c, City;City Lights
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530955886-1.jpg