meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='381894' 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, 1721991397
ffd_listing_title, 4234 24th Street, San Francisco, CA, 94114
ffd_mls_id, 424046962
ffd_salesforce_id, a0EUd000002XohgMAC
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 0
address2__c, 4234 24th Street, San Francisco, CA, 94114
pba__address_pb__c, 4234 24th Street, San Francisco, CA, 94114
agent_only_remarks__c, Contact Robin Hubinsky @ 415.939.4028, or Nick Honda at 415.678.0998 to schedule a private showing. Total square footage of the project including the 2-car garage is 5,475 square feet. Living space is 4,912 per floor plans.
appliances__c, Dishwasher;Disposal;Tankless Water Heater;Electric Cook Top;Built-In BBQ;Wine Refrigerator;Built-In Refrigerator;Solar Water Heater
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 7
year_build_text__c, 2024
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Nick S Honda
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-07-11T10:48:51.000+0000
days_on_market__c, 15
dom__c, 15
ffd_description_pb, Situated on a highly desirable street in Noe Valley, this new construction home has been thoughtfully built with an eye on high design and functionality. Spanning over 4 floors and with an elevator from the garage to the upper floor ensures that the home provides the flexibility needed for today's living. Upon entering it is immediately evident that the finishes are unique, timeless, and offer a sense of warmth and richness, not seen in many new homes. Warm wood panels, stylized staircase, solid stone and marble sinks, custom lighting features, large picture windows and doors are just some of the many design elements. A large living and dining area seamlessly integrate with a Chef's kitchen while offering outlooks to the landscaped yard with custom bench seating, thoughtful landscaping and a built-in BBQ. The heart of the kitchen is an expansive island finished with a waterfall countertop. The home features 3 primary suites and 4 additional bedrooms. The 3rd floor offers 3 bedrooms and 2 baths on the same floor, a feature that is very desirable, yet hard to find. A family room with deck provides south facing views towards Bernal Heights. While the home is a legal 2-unit building, the additional common areas provide space for a media room, family room, office, or guest quarters.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Family Room
pba__floortype_pb__c, Tile;Wood;Stone
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Radiant Floor;Solar Heating;Fireplace(s);Fireplace Insert;MultiZone
ffd_lastmodifieddate, 2024-07-26T10:48:10.000+0000
pba__latitude_pb__c, 37.7512828
pba__latitude_property__c, 37.7512828
laundry_features__c, Washer/Dryer Stacked Included;Upper Floor;Ground Floor;Cabinets
listed_date__c, 2024-06-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Robin
pba__listing_agent_lastname__c, Hubinsky
listing_agent_mls_id__c, 802803
ffd_listingagentname, Robin Hubinsky
listing_agent_number__c, 802803
listing_co_agent_mls_id__c, 810685
listing_co_agent_number__c, 1047456
listing_co_office_mls_id__c, DRMH
listing_co_office_name__c, Realty World Bay Area Real Estate
listing_co_office_number__c, 166014045
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 8179000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4372184
mls_id__c, 424046962
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-07-11
open_house_end__c, 2024-07-28T17:00:00.000+0000
open_house_start__c, 2024-07-28T14:00:00.000+0000
original_price__c, 8179000
overall_days_on_market__c, -82006
parking_access__c, Side by Side
parking_features__c, EV Charging,Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
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, 1665.11
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000002XohgMAC
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Fire Alarm
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, 4912
size__c, 4912
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 24th
subdist__c, Noe Valley
ffd_name, 4234 24th Street, San Francisco, CA, 94114
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 2024
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530805510-1.jpg