meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='397574' 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-05-08 08:45:37
[post_modified_gmt] => 2024-05-08 15:45:37
[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, 1727607150
ffd_listing_title, 464 Hoffman Avenue, San Francisco, CA, 94114
ffd_mls_id, 424065583
ffd_salesforce_id, a0EUd0000036unNMAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 464 Hoffman Avenue, San Francisco, CA, 94114
pba__address_pb__c, 464 Hoffman Avenue, San Francisco, CA, 94114
agent_only_remarks__c, Put your best foot forward - seller will consider ALL offers. Offers to be submitted on SFAR purchase contract with signed disclosure cover page, preapproval letter and proof of funds. Escrow opened with Michelle Patterson at WFG Title. Call or text Luba at 415-307-1392 for showings. Available disclosures at https://app.disclosures.io/link/464-Hoffman-Ave-id3kz285 - will be updated as they come in.
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range;Gas Plumbed
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1946
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jesse E Fowler
pba__contingentdate__c, 2024-09-26
ffd_createddate, 2024-09-14T02:46:57.000+0000
days_on_market__c, 16
dom__c, 16
ffd_description_pb, Welcome to this meticulously remodeled 3-bedroom, 2.5-bath modern retreat w/ 1-car parking, nestled in the heart of Noe Valley on an idyllic tree-lined street. Thoughtfully designed for seamless indoor-outdoor living, the open great room features a 4-panel panoramic accordion door that opens fully to a concrete patio w/ a pre-installed gas line, perfect for your dream grill or firepit. The spacious terraced yard offers multiple levels for gatherings, anchored by a magnificent mature oak tree, w/ a bonus 100 sq ft office/art studio at the top. Upstairs, all bedrooms provide privacy & comfort, including the primary bedroom w/ its own private deck. The conveniently located laundry room near the bedrooms adds ease to daily tasks. The chef's kitchen is outfitted w/ custom solid wood cabinetry, Caesarstone countertops, Thermador stove & Fischer & Paykel fridge, illuminated by high-efficiency LED & under-cabinet lighting. Tech enthusiasts will appreciate the Ubiquity/Unify camera system, Cat 6 & coax wiring, plus Nest thermostat & MyQ garage opener. Structural upgrades include a reinforced foundation w/ 3 steel beams, new front stucco, & Hardy Backer siding on the rear.
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Wood;Full
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2024-09-29T10:47:25.000+0000
pba__latitude_pb__c, 37.7498562
pba__latitude_property__c, 37.7498562
laundry_features__c, Laundry Closet;Upper Floor;Washer Included;Dryer Included;Gas Hook-Up
listed_date__c, 2024-09-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Luba
pba__listing_agent_lastname__c, Muzichenko
listing_agent_mls_id__c, 806066
ffd_listingagentname, Luba Muzichenko
listing_agent_number__c, 166016229
listing_co_agent_mls_id__c, 802084
listing_co_agent_number__c, 802084
listing_co_office_mls_id__c, JEFRE
listing_co_office_name__c, Jesse E. Fowler
listing_co_office_number__c, 28859
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 2795000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/1009235303
pba__longitude_pb__c, -122.4407484
mls_id__c, 424065583
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-13
original_price__c, 2795000
overall_days_on_market__c, -82070
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
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, 0
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000036unNMAQ
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, Contingent - Show
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Hoffman
subdist__c, Noe Valley
ffd_name, 464 Hoffman Avenue, San Francisco, CA, 94114
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1946
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530842004-1.jpg
