meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212741' 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-03-07 13:06:57
[post_modified_gmt] => 2024-03-07 21:06:57
[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, 3723 24th Street, San Francisco, CA, 94114
ffd_mls_id, 499694
ffd_salesforce_id, a0E1I00000SxuIyUAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 2
address2__c, 3723 24th Street, San Francisco, CA, 94114
pba__address_pb__c, 3723 24th Street, San Francisco, CA, 94114
agent_only_remarks__c, Offers will be reviewed on Sept 30, 2020. Contact Naomi for COVID-safe showings. Disclosures available on IO.
appliances__c, Gas Range
architectural_style__c, Contemporary;Traditional
bath_features__c, Shower Stall(s);Tub;Split Bath;Remodeled;Marble
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-07-02T21:54:53.000+0000
days_on_market__c, 1112
dom__c, 75
ffd_description_pb, Smart and chic remodeled lower floor condominium with three bedrooms/1.5 bathrooms on one level. This lovely north facing home with south facing terraced garden is primely located on 24th St x Dolores in Noe Valley. The front living and dining rooms are sun filled and boast parquet floors, coved ceilings and moldings, and a fireplace in the living room. The kitchen is ample and well designed with stainless steel appliances, and abundant counter and cabinet space. The recently remodeled marble and brass bathroom oozes style and design, with separate tub and shower. The home features two rear bedrooms and one side bedroom, all ample. The charming master bedroom opens directly to the terraced rear yard with multiple play, relaxing, eating, and planting areas. The home features in-unit laundry, a huge independent parking spot w/extra storage & work area. This home is ideally located on a quiet residential strip in the 24th St corridor, accessible to many amenities & transportation.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floor__c, 0
pba__floortype_pb__c, Wood;Parquet
hoa_dues__c, 300
hoa_fee_includes__c, Trash,Maintenance Grounds,Homeowners Insurance,Water
pba__hoafees__c, 300
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:24:54.000+0000
pba__latitude_pb__c, 37.751554
pba__latitude_property__c, 37.751554
laundry_appliances__c, Washer/Dryer
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-05-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Naomi
pba__listing_agent_lastname__c, Lempert Lopez
listing_agent_mls_id__c, 800407
ffd_listingagentname, Naomi Lempert Lopez
listing_agent_number__c, 800407
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 1450000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=1SUaUAZJE1V&brand=0
pba__longitude_pb__c, -122.4257
pba__lotsize_pb__c, 0
mls_id__c, 499694
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000001Vi19UAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-07-02
original_price__c, 1595000
overall_days_on_market__c, 182
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2020-09-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000SxuIyUAJ
sale_date__c, 2020-10-09
sale_price__c, 1515000
selling_agent_mls_id__c, 804988
selling_agent_name__c, Stephanie A. Johnson
selling_agent_number__c, 166014739
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 24th
subdist__c, Noe Valley
ffd_name, 3723 24th Street, San Francisco, CA, 94114
transportation__c, 1 Block
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/364685-1.jpg
ListingId, a0E1I00000SxuIyUAJ