meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237624' 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
(
)
)
ffd_listing_title, 4123 23rd 4125 Street, San Francisco, CA, 94114
ffd_mls_id, 422643882
ffd_salesforce_id, a0E8W00000WhhuKUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 11
of_units__c, 0
address2__c, 4123 23rd 4125 Street, San Francisco, CA, 94114
pba__address_pb__c, 4123 23rd 4125 Street, San Francisco, CA, 94114
agent_only_remarks__c, - OFFER DATE: Contact Listing Agent - Appointments: 24 hr notice/ NO lockbox. Text Eric Johnson at 415.518.5513 Chicago Title Co. Gerrie Brindley 415.252.2746; Gerrie.Brindley@ctt.com Please include Buyer signed Disclosure Package cover sheet with offer, As-Is addendum, and proof of funds/loan letter with offer. Allow 48 hour response on offers. LEGAL 2 UNIT BUILDING: Although this property currently functions like a 4br/2.5bath single family home, it is technically a 2 unit building with a 2br/1.5ba top unit & a 1br/1ba lower unit. Buyer to investigate and discern best use, relative to zoning and city/county requirements.
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1906
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-05-28
ffd_createddate, 2022-04-22T01:47:17.000+0000
days_on_market__c, 454
dom__c, 50
ffd_description_pb, - NEW PRICE Improvement! Noe Valley - Rare opportunity to own a beautifully restored home that celebrates classic San Francisco architecture both inside & out. Currently configured like a single residence, the top two floor main house is internally connected to the downstairs unit. This flexible floor plan can accommodate a variety of uses and lifestyles, and should not be missed. Merging traditional charm with modern conveniences, the kitchen boasts custom cabinetry, stone counters, and an impressive cooking range by LA CORNUE of FRANCE. Other features include oak wood flooring throughout, formal dining room, an uncommonly spacious upstairs veranda overlooking 23rd St, large backyard deck w/BBQ cook station included; a side tradesman entrance and more. Located within two blocks of Noe Valley's 24th St shopping district, you will enjoy easy access to a multitude of cafes, shops, restaurants, Whole Foods, and various public and corporate transportation options. MUST SEE
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Gas Starter;Family Room
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2023-07-13T17:08:45.000+0000
pba__latitude_pb__c, 37.752687
pba__latitude_property__c, 37.752687
listed_date__c, 2022-04-21
pba__listing_agent_email__c, eric@ericjohnsonsf.com
pba__listing_agent_firstname__c, Eric
pba__listing_agent_lastname__c, Johnson
listing_agent_mls_id__c, 805920
ffd_listingagentname, Eric M Johnson
listing_agent_number__c, 166016005
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, 2297000
pba__listingtype__c, Sale
pba__listing_website__c, http://23rdStreetSF.com
pba__longitude_pb__c, -122.434751
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Street Entrance
mls_id__c, 422643882
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Retreat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-04-21
original_price__c, 2497000
overall_days_on_market__c, -81194
pba__pendingdate__c, 2022-06-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1096.59
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000WhhuKUAR
sale_date__c, 2022-06-21
sale_price__c, 2350000
selling_agent_mls_id__c, 806048
selling_agent_number__c, 166016199
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, 2143
size__c, 2143
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 23rd
subdist__c, Noe Valley
ffd_name, 4123 23rd 4125 Street, San Francisco, CA, 94114
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530442736-1.jpg