meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='378634' 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, 1717124222
ffd_listing_title, 3888 23rd Street, San Francisco, CA, 94114
ffd_mls_id, 424027195
ffd_salesforce_id, a0EUd000001qB21MAE
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 2
address2__c, 3888 23rd Street, San Francisco, CA, 94114
pba__address_pb__c, 3888 23rd Street, San Francisco, CA, 94114
agent_only_remarks__c, Please contact Dana Cohen for disclosures & showings. [email protected] or (415) 305-3539. Sellers and Agents do not warrant square footage. Buyers to investigate all information provided to their own satisfaction. All buyers to use the most current 8-page SFAR contract. Escrow open with Heather Shiffer @ First American Title.
appliances__c, Dishwasher;Disposal;Free Standing Gas Oven;Free Standing Gas Range
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-04-25T17:46:42.000+0000
days_on_market__c, 35
dom__c, 14
ffd_description_pb, Welcome to 3888 23rd St, your gateway to Noe Valley living! Nestled on a coveted street, just two blocks away from the vibrant 24th Street corridor, this top-floor home is a tranquil retreat within reach of every urban convenience. A private entrance ushers you into a meticulously maintained interior adorned with timeless period details, soaring ceilings, and generously proportioned rooms. The inviting living room boasts bay windows, a cozy gas fireplace, and ornate light medallions that echoes throughout the home. Entertain with ease in the expansive dining room, seamlessly flowing into the remodeled kitchen replete with ample storage and counter space. Adjacent, a charming breakfast nook offers a picturesque view of the secluded private outdoor sanctuary, perfect for alfresco gatherings. Retreat to the primary suite, complete with spacious closets and a remodeled spa-like en-suite bathroom. Two additional well-appointed bedrooms share a conveniently situated second bathroom, ensuring comfort for all. All the boxes are checked including in-unit laundry, independent parking, abundant storage, and low HOA dues. Step outside, and you're immersed in the vibrant tapestry of Noe Valley living, with boutique shops, eclectic eateries, and the renowned farmers market mere moments away.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Starter
pba__hoafees__c, 288
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-05-31T02:49:58.000+0000
pba__latitude_pb__c, 37.753392
pba__latitude_property__c, 37.753392
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2024-04-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dana
pba__listing_agent_lastname__c, Cohen
listing_agent_mls_id__c, 812281
ffd_listingagentname, Dana Cohen
listing_agent_number__c, 1055972
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, RIVET
listing_office_name__c, Rivet Real Estate
listing_office_number__c, 28789
pba__listingprice_pb__c, 1628000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.3888-23rdst.com/
pba__longitude_pb__c, -122.429502
mls_id__c, 424027195
master_bathroom_features__c, Double Sinks
master_property__c, a0OUd000006RuAkMAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-04-25
original_price__c, 1628000
overall_days_on_market__c, -81929
parking_access__c, Independent
parking_features__c, Enclosed
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-05-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-05-30T13:39:18.000+0000
price_per_square_foot__c, 1250
pba__propertytype__c, Condominium
ListingId, a0EUd000001qB21MAE
sale_date__c, 2024-05-30
sale_price__c, 1925000
selling_agent_mls_id__c, MLSL5077460
selling_agent_number__c, 981323115
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1540
size__c, 1540
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 23rd
subdist__c, Noe Valley
ffd_name, 3888 23rd Street, San Francisco, CA, 94114
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530767152-1.jpg