meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330457' 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, 667 28th Street, San Francisco, CA, 94131
ffd_mls_id, 423727315
ffd_salesforce_id, a0E8W00000bFuV9UAK
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 667 28th Street, San Francisco, CA, 94131
pba__address_pb__c, 667 28th Street, San Francisco, CA, 94131
agent_only_remarks__c, Seller requests any offers to be submitted on Wednesday, March 29th by 12noon. Please allow 24 hours for a response from out of area Seller. Email [email protected] for ALL showing requests and do NOT send Text Messages or use Showing Time. www.ModernOn28th.com Escrow opened with Kevin Thompson of First American. Buyer to satisfy themselves with sqft measurements and parking. Floorplan Visuals measured at 1,855sqft. Please use most current SFAR Purchase Contract, allow 24 hours to respond, include fully executed disclosure package, and 1 business day for the initial deposit.
appliances__c, Dishwasher;Free Standing Refrigerator;Free Standing Electric Range
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1939
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-17T19:48:28.000+0000
days_on_market__c, 124
dom__c, 13
ffd_description_pb, Welcome to this stunning luxury remodeled home perched in the heart of Noe Valley. 667 28th Street offers 3 bedrooms, 2 full bathrooms, and a harmonious blend of modern design, comfort, and functionality. The main level great room is a dramatic showpiece, featuring soaring high ceilings, vibrant natural light, superb downtown San Francisco views, and a remodeled open kitchen with dazzling white quartz counters. The spacious primary suite is a haven of tranquility, boasting a sitting area, built-in closets, a luxurious bathroom, and direct backyard access. Two generously proportioned guest bedrooms also offer direct backyard access. The beautifully landscaped flat garden features a large artificial turf lawn and seating area. Located in the highly sought after neighborhood of Noe Valley, this home provides easy access to an abundance of gourmet restaurants, lively cafes, trendy boutiques, and picturesque parks, making it the perfect urban oasis.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T18:34:33.000+0000
pba__latitude_pb__c, 37.7445283
pba__latitude_property__c, 37.7445283
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2023-03-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Greg
pba__listing_agent_lastname__c, Fulford
listing_agent_mls_id__c, 804156
ffd_listingagentname, Greg Fulford
listing_agent_number__c, 166013627
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 2395000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.ModernOn28th.com
pba__longitude_pb__c, -122.4370845
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 423727315
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, 2023-03-17
original_price__c, 2395000
overall_days_on_market__c, -81524
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-03-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bFuV9UAK
sale_date__c, 2023-04-26
sale_price__c, 2660000
selling_agent_mls_id__c, 813200
selling_agent_number__c, 1060085
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 28th
subdist__c, Noe Valley
ffd_name, 667 28th Street, San Francisco, CA, 94131
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1939
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530592091-1.jpg
_wp_old_slug, 667-28th-street-san-francisco-ca-94131-2