meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235400' 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, 1019 Guerrero Street, San Francisco, CA, 94110
ffd_mls_id, 421616732
ffd_salesforce_id, a0E8W00000V3JREUA3
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 3
address2__c, 1019 Guerrero Street, San Francisco, CA, 94110
pba__address_pb__c, 1019 Guerrero Street, San Francisco, CA, 94110
agent_only_remarks__c, Please TEXT Kristen for all showing requests @ 1.415.637.7265. Roof rights for roof deck above the garage shared with neighbor, if neighbor decides not to participate in cost, the roof deck will be for this unit. See CCR's, buyer to investigate to their satisfaction. Exterior of building painted Dec 2021. All offers to be submitted on a San Francisco Purchase Agreement. If you do not have access to this document, kindly let us know and we can provide one for you. Property shown subject to tenant rights- best days to show are Mon, Tues and weekends.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1880
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-03-11
ffd_createddate, 2022-01-24T17:46:47.000+0000
days_on_market__c, 541
dom__c, 72
ffd_description_pb, Gorgeous, newly remodeled top floor residence nestled perfectly on the border of Noe Valley and the Mission's Valencia Street corridor - offering the best of both worlds and all these fabulous neighborhoods have to offer. This top floor, corner, condo residence recently went under a cosmetic refresh and features a new kitchen, refinished floors, newly painted and so much more. Flexible floor-plan offering 2+BD and 1.5BA. Main bath has two showers. Large covered deck off of the kitchen. Classic details with a modern flair. Moments to boutique shopping, eclectic restaurants, craft cocktail bars, artisanal coffee shops, shuttles, freeways, Dolores Park and all the Noe Valley and the Mission has to offer. Don't miss out on this residence that has it all - storage and garage parking to boot. Current rent is $5,000.
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 300
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-04-21T10:50:39.000+0000
pba__latitude_pb__c, 37.754509
pba__latitude_property__c, 37.754509
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Other
listed_date__c, 2022-01-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rachel
pba__listing_agent_lastname__c, Swann
listing_agent_mls_id__c, 807382
ffd_listingagentname, Rachel Swann
listing_agent_number__c, 1016936
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, 1399000
pba__listingtype__c, Sale
pba__listing_website__c, https://noemissioncondo.com/
pba__longitude_pb__c, -122.422845
lower_level__c, Street Entrance
mls_id__c, 421616732
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000003COd1UAG
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-01-24
original_price__c, 1399000
overall_days_on_market__c, -81107
parking_access__c, Side by Side
parking_features__c, Detached,Garage Door Opener,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Back Porch;Covered Deck
pba__pendingdate__c, 2022-04-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-04-20T16:30:57.000+0000
price_per_square_foot__c, 1184.74
pba__propertytype__c, Condominium
id, a0E8W00000V3JREUA3
sale_date__c, 2022-04-14
sale_price__c, 1475000
selling_agent_mls_id__c, E01754
selling_agent_number__c, 981097595
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Berkshire Hathaway
pba__status__c, Closed
pba__totalarea_pb__c, 1245
size__c, 1245
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Guerrero
subdist__c, Noe Valley
ffd_name, 1019 Guerrero Street, San Francisco, CA, 94110
view__c, City;City Lights;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1880
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530390551-1.jpg
ListingId, a0E8W00000V3JREUA3