meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215172' 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, 3806 22nd Street, San Francisco, CA, 94114
ffd_mls_id, 507159
ffd_salesforce_id, a0E1I00000THqOIUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 3806 22nd Street, San Francisco, CA, 94114
pba__address_pb__c, 3806 22nd Street, San Francisco, CA, 94114
agent_only_remarks__c, More at www.HomeOn22nd.com. For showings, please call or text Ron Abta: 415-595-7661. Escrow opened with Steve Salviejo, (415) 346-0122, from North American Title. Showings by appointment only. *In-person showings permitted after the PEAD is signed and returned. PLEASE NOTE: The seller has NOT verified that the property has been properly disinfected and is NOT providing personal protective equipment at the property to protect against exposure to COVID-19. Any party who enters the home must provide their own appropriate protective items and must enter at their own risk. Buyers should investigate to their satisfaction.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;Double Oven
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-30T10:46:14.000+0000
days_on_market__c, 1023
dom__c, 70
ffd_description_pb, Just steps to the vibrant retail of 24th St., this 4 bed / 3 bath home will impress you with its upgrades, high ceilings, and open floor plan. Located on one of the best, flat blocks in Noe Valley, the house greets you with its high ceilings, warm living spaces, and an open floor plan with the kitchen, living room, and dining room all open to each other. The gourmet kitchen enjoys a Wolf range, large marble center island, and an abundance of cabinetry. A breakfast nook, bedroom, and full bath complete the impressive main living level. Walk upstairs to sizable bedrooms with walk-in closets and great outlooks. The downstairs was recently remodeled with radiant heat and expanded to include a 4th bedroom with separate entrance, laundry room, kitchenette, and huge family area perfect for entertaining. The landscaped backyard is inviting and private. A 93 Walk Score (Walker's Paradise) completes this incredible house.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:36:13.000+0000
pba__latitude_pb__c, 37.754832
pba__latitude_property__c, 37.754832
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-09-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ron
pba__listing_agent_lastname__c, Abta
listing_agent_mls_id__c, 803878
ffd_listingagentname, Ron Abta
listing_agent_number__c, 166013231
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, POLARISR
listing_office_name__c, Polaris Realty
listing_office_number__c, 27749
pba__listingprice_pb__c, 3295000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.houseon22nd.com
pba__longitude_pb__c, -122.43257
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 507159
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-29
original_price__c, 3295000
overall_days_on_market__c, 93
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-12-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 898.86
pba__propertytype__c, Single Family Residence
id, a0E1I00000THqOIUA1
room_type__c, Laundry
sale_date__c, 2021-01-05
sale_price__c, 3155000
selling_agent_mls_id__c, 803139
selling_agent_name__c, Wendy M. Storch
selling_agent_number__c, 803139
selling_co_agent_mls_id__c, 811258
selling_co_agent_name__c, Melissa A. Montoya
selling_co_agent_number__c, 1050698
selling_co_office_mls_id__c, STHB
selling_co_office_name__c, Sotheby's International Realty
selling_co_office_number__c, 2050
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 3510
size__c, 3510
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 22nd
subdist__c, Noe Valley
ffd_name, 3806 22nd Street, San Francisco, CA, 94114
transportation__c, 1 Block
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371306-1.jpg
ListingId, a0E1I00000THqOIUA1
