meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375740' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12160
[post_author] => 4
[post_date] => 2018-10-29 19:47:38
[post_date_gmt] => 2018-10-29 19:47:38
[post_content] => Proximity to parks, room to roam in the bigger-than-some-SF-neighborhoods yards, and lots of great eateries and local haunts. Downtown is a quick (and probably crowded) N-Judah ride away, and car commuters can hop on 19th Avenue to head south. Yes, there’s more fog than on the east side of town, but that keeps things cool and comfy.
[post_title] => Central Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-07 23:32:48
[post_modified_gmt] => 2024-11-08 07:32:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12160
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1735681095
ffd_listing_title, 1647 25th Avenue, San Francisco, CA, 94122
ffd_mls_id, 424013873
ffd_salesforce_id, a0EUd000001OEKdMAO
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1647 25th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1647 25th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, The disclosure packet is available on homelight/IO and here is the link: https://app.disclosures.io/link/1647-25th-Avenue-dclga7th The lower level unit is tenant occupied and will be shown during the weekdays, and during the designated showing schedule. The upper level can be shown by appointment. The upper level was measured by the graphic artist at approximately 1,445 square feet, and the lower level at approximately 560 square feet. The tenant has requested NO PHOTOS OR VIDEOS to be taken in their unit and for shoe coverings to be used. We will provide the shoe coverings. Please contact the listing agent for further details and to schedule showings (email is best).---OFFER DATE WEDNESDAY 3/20/2024 BY 12:00PM---
appliances__c, Dishwasher;Gas Water Heater;Built-In Gas Range;Built-In Refrigerator;Gas Plumbed
architectural_style__c, Contemporary;Modern/High Tech;Traditional
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1928
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-08T18:46:55.000+0000
days_on_market__c, 298
dom__c, 12
ffd_description_pb, Sensational and stylish three bedroom, two and a half bath updated home showcasing sophisticated finishes, a comfortable floor plan and a stellar central Sunset location! The home opens to an inviting formal entryway, large formal living room with fireplace, and a cheerful dining area with gorgeous wood floors showered with natural light. The spacious gourmet eat-in kitchen has been thoughtfully remodeled with high-end appliances, and modern accents highlighting contemporary design and timeless warmth. There are two bedrooms privately tucked away at the back of the home that overlook the flat backyard/garden, and two remodeled bathrooms with designer finishes all on the same level. The lower level of the property has an additional living area, bedroom, bathroom, and separate access from the street level. The substantial garage space with ample room for storage provides the final touches to this special home that is close to restaurants, shopping, cafes, parks, playgrounds, Ocean beach, Golden gate park, and more!
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room;Wood Burning;Brick
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Wall Furnace;Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2024-04-17T00:47:02.000+0000
pba__latitude_pb__c, 37.7567811
pba__latitude_property__c, 37.7567811
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2024-03-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jeffrey
pba__listing_agent_lastname__c, Salgado
listing_agent_mls_id__c, 805001
ffd_listingagentname, Jeffrey A Salgado
listing_agent_number__c, 166014760
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 1259000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=yf7tHF7Dpj9
pba__longitude_pb__c, -122.4833803
lower_level__c, Bedroom(s),Full Bath(s),Street Entrance
mls_id__c, 424013873
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2024-03-08
original_price__c, 1259000
overall_days_on_market__c, -81881
parking_access__c, Side by Side
parking_features__c, Attached,Covered,Enclosed,Interior Access,Size Limited,Uncovered Parking Space
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-03-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-11T09:37:08.000+0000
price_per_square_foot__c, 798
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001OEKdMAO
room_type__c, Kitchen;Studio;Living Room;Baths Other;Dining Room
sale_date__c, 2024-04-10
sale_price__c, 1600000
security_features__c, Security Gate
selling_agent_mls_id__c, 816292
selling_agent_number__c, 1075258
selling_co_agent_mls_id__c, MLSL5099918
selling_co_agent_number__c, 981400010
selling_co_office_mls_id__c, COMPS-16
selling_co_office_name__c, Compass
selling_co_office_number__c, 981090503
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2005
size__c, 2005
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 25th
subdist__c, Central Sunset
ffd_name, 1647 25th Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1928
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530741939-1.jpg