meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219347' 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, 579 Clipper Street, San Francisco, CA, 94114
ffd_mls_id, 421560680
ffd_salesforce_id, a0E1I00000UU7RnUAL
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 579 Clipper Street, San Francisco, CA, 94114
pba__address_pb__c, 579 Clipper Street, San Francisco, CA, 94114
agent_only_remarks__c, book your showing @ https://calendly.com/team-da/579-clipper-street Email [email protected] for questions or other showing times. All Showings per COVID Protocol. Escrow opened with Michelle Patterson at North American Title Company.
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Alla Gershberg
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-06-11T00:47:33.000+0000
days_on_market__c, 769
dom__c, 5
ffd_description_pb, This hip, immaculately designed residence w/ smart-home features in the highly coveted Noe Valley neighborhood is a homeowner's dream of both form & function. Newly expanded with the greatest attention to detail this remodeled down to the studs masterpiece has all the luxuries of modern living! Multiple outdoor spaces including decks, patios, and direct access to the large & beautifully landscaped backyard provide plenty of room to play and entertain! From the stylish living space and the envy-inducing chef's kitchen w/ Thermador pro appliances to the glass staircase that leads to the magical primary suite, additional bedrooms, plus multiple family rooms--this home has it all. Built with the future in mind, the home is made complete by the state of the art home automation system, hard-wired security and 220v plug EV charger. A+ location just steps from 24th Street shops & restaurants, parks & blocks away to Muni with easy access to freeways! Don't miss this Modern Masterpiece!
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Electric
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
has_3d_tour__c, 1
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:54:32.000+0000
pba__latitude_pb__c, 37.7484594
pba__latitude_property__c, 37.7484594
laundry_features__c, Upper Floor;Washer Included;Dryer Included
listed_date__c, 2021-06-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dale
pba__listing_agent_lastname__c, Boutiette
listing_agent_mls_id__c, 806303
ffd_listingagentname, Dale T Boutiette
listing_agent_number__c, 166016715
listing_co_agent_mls_id__c, 803120
listing_co_agent_number__c, 803120
listing_co_office_mls_id__c, COMP7PAR
listing_co_office_name__c, Compass SF
listing_co_office_number__c, 27677
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 4500000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=Qrsbp6PJ2j1
pba__longitude_pb__c, -122.4377144
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Partial Bath(s)
mls_id__c, 421560680
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-06-10
original_price__c, 4500000
overall_days_on_market__c, 112
parking_access__c, Independent
parking_features__c, Attached,EV Charging,Garage Facing Front
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Covered Patio
pba__pendingdate__c, 2021-06-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1402.84
pba__propertytype__c, Single Family Residence
id, a0E1I00000UU7RnUAL
sale_date__c, 2021-07-06
sale_price__c, 4750000
selling_agent_mls_id__c, 802317
selling_agent_number__c, 802317
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Jackson Fuller Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 3386
size__c, 3386
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Clipper
subdist__c, Noe Valley
ffd_name, 579 Clipper Street, San Francisco, CA, 94114
view__c, City;Downtown
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530258521-1.jpg
ListingId, a0E1I00000UU7RnUAL