meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='320599' 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, 411 Clipper Street, San Francisco, CA, 94114
ffd_mls_id, 422705652
ffd_salesforce_id, a0E8W00000ZMBDMUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 411 Clipper Street, San Francisco, CA, 94114
pba__address_pb__c, 411 Clipper Street, San Francisco, CA, 94114
agent_only_remarks__c, VACANT SUPRA LOCKBOX, Show 24/7, Full disclosure package available upon request BY EMAIL ONLY. Offers welcome by 10:00 am Wednesday, on November 16, 2022. NO PREMPTIVE offers will be reviewed.Seller reserves the right to reject any and all offers. Buyer to use SFAR contract. Buyer to sign the entire disclosure package and MANDATORY ADDENDA. Any offer without signed disc pak and addenda will be deemed incomplete and void. This is a successor TRUSTEE sale with NO COURT confirmation. Longtime lady owner, nearly the age of 100 years, died in the home of natural causes within the last 3 years.
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Katie A Tostanoski
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-10-31T16:46:20.000+0000
days_on_market__c, 261
dom__c, 17
ffd_description_pb, Prime NOE Valley location comes with THREE bedrooms, One bathroom, SINGLE FAMILY HOME. Great walk score to all the BEST NOE AMENITIES at an unbelievable LOW PRICE. Home features PEEK-A-VIEWS of the CITY downtown skyline, FORMAL DINING ROOM w/ built-ins, Eat-In Kitchen w/ Pantry, HARDWOOD FLOORS, soaring ceilings, brick WOOD-BURNING FIREPLACE, rear fenced garden, BAY windows, Washer/Dryer, HUGE TWO CAR GARAGE plus BONUS 2 CAR OFF STREET parking on an over 3000 SQUARE FOOT LOT. This SEMI-DETACHED fixer-upper property needs work but the upside to owning a NOE VALLEY single family home at this SUPER LOW PRICE is tremendous. This home will not last on the market very long. COME SEE QUICK!!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas;Fireplace(s)
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-07-13T18:03:19.000+0000
pba__latitude_pb__c, 37.748613
pba__latitude_property__c, 37.748613
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2022-10-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Hawko
listing_agent_mls_id__c, 378394
ffd_listingagentname, Tim Hawko
listing_agent_number__c, 378394
listing_co_agent_mls_id__c, 810040
listing_co_agent_number__c, 1044436
listing_co_office_mls_id__c, PKNO
listing_co_office_name__c, Park North Real Estate
listing_co_office_number__c, 24343
listing_office_mls_id__c, PKNO
listing_office_name__c, Park North Real Estate
listing_office_number__c, 24343
pba__listingprice_pb__c, 998000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.434473
lower_level__c, Garage
mls_id__c, 422705652
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2022-10-31
original_price__c, 998000
overall_days_on_market__c, -81387
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Garage Facing Front,Tandem Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2022-11-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1105.44
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZMBDMUA5
room_type__c, Living Room;Dining Room
sale_date__c, 2022-12-07
sale_price__c, 1625000
security_features__c, Window Security Bars
selling_agent_mls_id__c, 810608
selling_agent_number__c, 1047270
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Polaris Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1470
size__c, 1470
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Clipper
subdist__c, Noe Valley
ffd_name, 411 Clipper Street, San Francisco, CA, 94114
view__c, Downtown;San Francisco;Hills
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/530549208-1.jpg