meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218945' 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, 242 San Jose Avenue, San Francisco, CA, 94110
ffd_mls_id, 421548674
ffd_salesforce_id, a0E1I00000USugvUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 242 San Jose Avenue, San Francisco, CA, 94110
pba__address_pb__c, 242 San Jose Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Offers will be reviewed Wednesday, May 19th at 11am. 3D tour: https://my.matterport.com/show/?m=bo3LUkYa478&mls=1. For showings: https://calendly.com/taylor-williams-mws/242-san-jose-showings?month=2021-05&date=2021-05-16. PLEASE NOTE SHOWINGS ARE HOSTED. PLEASE CONTACT TO CANCEL. For additional showings and disclosures please email [email protected]. 2nd parking space is driveway. Sellers made use of it without issue. Please note MWS team does not clean/disinfect between showings. Buyers responsible for their own PPE. Escrow opened with Liz Paglinawan, First American Title, [email protected], escrow #6544253.
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Double Oven;Built-In Refrigerator
bath_features__c, Tub w/Shower Over;Tile;Skylight/Solar Tube;Window
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1916
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-05-14T22:48:18.000+0000
days_on_market__c, 796
dom__c, 5
ffd_description_pb, On an epic 175'-deep park-like lot on a quiet Noe Valley block just steps from the 24th Street and Valencia corridors, the backyard of this 4-5 bed recently renovated home deserves the title of Best Backyard in San Francisco''. On the Ipe deck eat meals prepared in the Green Egg or gourmet BBQ next to the barrel-sided tub & outdoor shower. Sit on the patio while kids play on the swings, shoot hoops, or play in the grass. Inside, the main level foyer w/ window seat is flanked by an expansive living room w/ fireplace & arched E-facing windows. A formal dining room w/ built-in banquette is next to a home office overlooking the yard. The gourmet kitchen has high-end appliances, custom hood, floating shelves & breakfast bar & opens into a sitting area. The 2nd level offers 4 spacious bedrooms & the primary suite features a W-facing deck & luxurious bath. Downstairs is a media room, 2nd laundry, 3rd full bath & office/gym/guest suite. Wine storage + 1 car complete this one-of-a-kind home.
district__c, SF District 5
entry_level__c, 0
exterior_features__c, BBQ Built-In;Fire Pit
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood;Stone
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:52:38.000+0000
pba__latitude_pb__c, 37.7512966
pba__latitude_property__c, 37.7512966
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Upper Floor;Ground Floor;Washer Included;Dryer Included
listed_date__c, 2021-05-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Missy
pba__listing_agent_lastname__c, Wyant Smit
listing_agent_mls_id__c, 804067
ffd_listingagentname, Missy Wyant Smit
listing_agent_number__c, 166013500
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 4495000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=bo3LUkYa478&mls=1
pba__longitude_pb__c, -122.4217784
lower_level__c, Family Room,Full Bath(s),Garage,Street Entrance
mls_id__c, 421548674
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Bidet;Soaking Tub;Marble;Window;Stone
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-05-14
original_price__c, 4495000
overall_days_on_market__c, 139
parking_access__c, Tandem
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Interior Access,Uncovered Parking Space
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-05-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1656.72
pba__propertytype__c, Single Family Residence
id, a0E1I00000USugvUAD
road_surface_type__c, Paved
room_type__c, Storage;Office;Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom;Media Room;Wine Storage Area
sale_date__c, 2021-05-26
sale_price__c, 5550000
selling_agent_mls_id__c, 807863
selling_agent_number__c, 1027872
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, 3350
size__c, 3350
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, San Jose
subdist__c, Noe Valley
ffd_name, 242 San Jose Avenue, San Francisco, CA, 94110
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1916
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530241398-1.jpg
ListingId, a0E1I00000USugvUAD