meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='220815' 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, 4121 Cesar Chavez Street #6, San Francisco, CA, 94131
ffd_mls_id, 421592089
ffd_salesforce_id, a0E1I00000UzzygUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 6
address2__c, 4121 Cesar Chavez Street #6, San Francisco, CA, 94131
pba__address_pb__c, 4121 Cesar Chavez Street #6, San Francisco, CA, 94131
agent_only_remarks__c, Shows beautifully - staged by Meridith Baer. Easy to show, txt, call, email Matt 415-264-7224 or [email protected] for an immediate appt. Lockbox is located to the left of the planters, which is left of the front door (but just to the right of the garage door). In lockbox there's a fob and a key. The fob will get you in the bldg (front door is really heavy) and you can fob in the elevator push 3F to go directly into unit. This is a relo sale, seller is: Graebel Relocation Services Worldwide ****** Neighbor in Bldg in #3 just sold in late April for $2,25M and was only a 2 bed, smaller unit (tax records show 1,434 sqft) on a lower floor ***** #1 in Bldg, ground floor unit, also just sold for $1,288 per sqft - this unit #6 has HUGE value! Buy now before SF re-opens completely and priced rise
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;Wine Refrigerator;Built-In Refrigerator
architectural_style__c, Contemporary;Modern/High Tech;Traditional
bath_features__c, Tub w/Shower Over;Tub;Tile;Radiant Heat;Quartz
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2008
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-11-09
cooling__c, None
ffd_createddate, 2021-09-07T18:47:19.000+0000
days_on_market__c, 680
dom__c, 78
ffd_description_pb, VIEWS from The Penthouse! Cesar Chavez is a rare cul-de-sac, no thru traffic; quiet & private in sunny Noe Valley. Luxe newer built bldg in 2008. This penthouse lives like a single-family boasting 3 amazing view decks; stunning views of the SF Skyline, The Bay & More! Boutique bldg, only 6 units. Elevator opens directly into unit. Pristine Condo: 3 bed + office/den, 3 bathrm top floor corner unit w/ an open floor plan & contemporary finishes. High end kitchen w/grand island, Thermador s/s appliances, SubZero fridge, Caesarstone slab counters. Hardwood floors throughout.Floating baseboards.Directly off kitchen is access to the backyard. The primary suite overlooking Downtown SF features a walk-in closet & high ceilings. Luxe en-suite primary bath is a spa retreat w/inviting soaking tub. Built-in speakers/sonos. In-unit laundry. Secure bldg. 1 car parking&storage in garage. Close to J-Church line, 24th St shops, restaurants, Glen Park, Cole+more. Easy access to 280
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Tile;Wood;Stone
pba__hoafees__c, 0
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 4121 Cesar Chavez Street Homeowners' Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant;MultiZone
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T16:00:47.000+0000
pba__latitude_pb__c, 37.747141
pba__latitude_property__c, 37.747141
laundry_features__c, Inside Room;Laundry Closet;Inside Area;Cabinets
listed_date__c, 2021-09-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Matthew
pba__listing_agent_lastname__c, Zampella
listing_agent_mls_id__c, 815293
ffd_listingagentname, Matthew Zampella
listing_agent_number__c, 1072036
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SRNO
listing_office_name__c, Sereno Group
listing_office_number__c, 877714322
pba__listingprice_pb__c, 2285000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.NoeValleyPenthouse.com
pba__longitude_pb__c, -122.432093
lower_level__c, Garage,Street Entrance
mls_id__c, 421592089
main_level__c, Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Tub;Quartz;Tile;Soaking Tub;Window;Radiant Heat;Stone
master_property__c, a0O1I000001ViqxUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-09-07
original_price__c, 2285000
overall_days_on_market__c, 115
parking_access__c, Side by Side
parking_features__c, Assigned,Attached,EV Charging,Garage Door Opener,Interior Access,Private,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2021-11-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1161.56
pba__propertytype__c, Condominium
id, a0E1I00000UzzygUAB
road_surface_type__c, Paved
roof__c, Flat
room_type__c, Storage;Office;Bonus Room;Laundry;Kitchen;Studio;Living Room;Master Bathroom;Dining Room;Master Bedroom
sale_date__c, 2021-12-13
sale_price__c, 2200000
security_features__c, Fire Alarm;Secured Access;Carbon Mon Detector;Panic Alarm
selling_agent_mls_id__c, 263622
selling_agent_number__c, 263622
selling_co_agent_mls_id__c, 800323
selling_co_agent_number__c, 800323
selling_co_office_mls_id__c, VANG03
selling_co_office_name__c, Vanguard Properties
selling_co_office_number__c, 1228
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1894
size__c, 1894
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Cesar Chavez
subdist__c, Noe Valley
ffd_name, 4121 Cesar Chavez Street #6, San Francisco, CA, 94131
view__c, City;Panoramic;City Lights;Bay;Downtown;San Francisco;Twin Peaks;Hills;Sutro Tower;Canyon
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Coverings
pba__yearbuilt_pb__c, 2008
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530317828-1.jpg
ListingId, a0E1I00000UzzygUAB