meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219060' 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, 4277 25th Street, San Francisco, CA, 94114
ffd_mls_id, 421554914
ffd_salesforce_id, a0E1I00000UTWGQUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 4277 25th Street, San Francisco, CA, 94114
pba__address_pb__c, 4277 25th Street, San Francisco, CA, 94114
agent_only_remarks__c, Offers, if any, will be reviewed Thursday, May 27th at 11 AM. Please try to visit or send clients to one of our open houses. If not possible, appointments may be made for private showings. Contact Sejal Binnings at 415-515-5266 for showing requests or email [email protected]. All visitors must comply with COVID19 mask and social distance guidelines. For disclosure requests, please follow this link: https://app.disclosures.io/link/4277-25th-Street-n3fs71bu
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Modern/High Tech;Traditional
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Payton R Stiewe
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-05-21T14:46:35.000+0000
days_on_market__c, 789
dom__c, 7
ffd_description_pb, Welcome to 4277 25th St. in Noe Valley! Having undergone a studs-out renovation in 2013, this thoughtfully updated home boasts 4BRs on one level, 3 full baths, a 1-car garage, and sunny, south-facing garden. The versatile layout features both formal & casual spaces, including an open kitchen / dining / family room setup that is perfect for entertaining! Chef's kitchen w/ high-end stainless appliances & center island w/ breakfast bar seating. Incredible indoor/outdoor flow & multiple Nana walls. Primary suite at rear of home for maximum privacy, featuring towering cedar-plank ceilings, huge walk-in closet, and luxuriously appointed bath w/ oversized stall shower w/ dual heads. Three additional generously-sized bedrooms on upper level w/ hall bath and laundry closet. Professional landscaping including grass terrace, play structure, herb/vege garden, and fruit trees. Radiant heat w/ 2 zones, integrated speaker system, ethernet, and clever built-ins / storage. Steps to 24th and much more!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant;MultiZone
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:53:12.000+0000
pba__latitude_pb__c, 37.7493979
pba__latitude_property__c, 37.7493979
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2021-04-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Arrian
pba__listing_agent_lastname__c, Binnings
listing_agent_mls_id__c, 806705
ffd_listingagentname, Arrian C Binnings
listing_agent_number__c, 166017483
listing_co_agent_mls_id__c, 802841
listing_co_agent_number__c, 802841
listing_co_office_mls_id__c, ARTEMIS
listing_co_office_name__c, Artemis Real Estate
listing_co_office_number__c, 28502
listing_office_mls_id__c, ARTEMIS
listing_office_name__c, Artemis Real Estate
listing_office_number__c, 28502
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__listing_website__c, http://noevalleyperfection.com
pba__longitude_pb__c, -122.4355599
lower_level__c, Dining Room,Family Room,Full Bath(s),Kitchen,Living Room
mls_id__c, 421554914
master_bathroom_features__c, Double Sinks;Tile;Multiple Shower Heads
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-05-21
original_price__c, 2995000
overall_days_on_market__c, 150
parking_access__c, Independent
parking_features__c, Detached,Enclosed,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch;Front Porch
pba__pendingdate__c, 2021-05-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1578.99
pba__propertytype__c, Single Family Residence
id, a0E1I00000UTWGQUA5
roof__c, Shingle
room_type__c, Kitchen;Living Room;Master Bathroom;Dining Room;Family Room;Master Bedroom
sale_date__c, 2021-06-07
sale_price__c, 3668000
selling_agent_mls_id__c, 811520
selling_agent_number__c, 1051920
selling_co_agent_mls_id__c, 807863
selling_co_agent_number__c, 1027872
selling_co_office_mls_id__c, COMP3
selling_co_office_name__c, Compass
selling_co_office_number__c, 27342
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2323
size__c, 2323
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 25th
subdist__c, Noe Valley
ffd_name, 4277 25th Street, San Francisco, CA, 94114
view__c, City Lights;Twin Peaks;Sutro Tower
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
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/530246869-1.jpg
ListingId, a0E1I00000UTWGQUA5