meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327154' 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-03-19 12:20:19
[post_modified_gmt] => 2024-03-19 19:20:19
[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
(
)
)
ffd_listing_title, 1443 29th Avenue, San Francisco, CA, 94122
ffd_mls_id, 423715395
ffd_salesforce_id, a0E8W00000a7n56UAA
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1443 29th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1443 29th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Neither seller nor LA shall guarantee accuracy of sq ft. Prospective purchasers are advised to independently verify accuracy & to review any disclosure information before submitting offer. Property is sold AS-IS. Please include 'EMD to be wired within 24 hours of contract ratification. Disclosures to be returned, signed in its entirety, within 48 hours of ratification.'as a term in the purchase agreement. Buyer to investigate to their own satisfaction. Call/text Simon 4158062610 if you have any questions. Offer date TBD. Disclosures ready. Home/Pest inspections completed by Diverse. Offers as they come.
appliances__c, Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c, Spanish
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1928
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-01-20T11:47:29.000+0000
days_on_market__c, 180
dom__c, 39
ffd_description_pb, This newly renovated SFH located in the Central Sunset is the definition of classic elegance. Open concept living room/kitchen/dining room has the perfect flow for an entertainment space. New hardwood floors, skylights throughout, Thermador appliances, in closet washer/dryer, quartz countertops, and Venetian plaster walls are some of the tasteful details that have been carefully thought out. Top floor has 2 BRs/2.5 Bth which includes a primary en suite BR. Both BRs have access to a large beautiful deck that leads to a freshly landscaped garden. The downstairs includes a family flex room and another 2BR/2Bth with another primary en suite bedroom and both have sliding doors that leads directly to the backyard. Beautifully spacious yard w/turf grass, planting areas, & new deck. Down the street from the N Judah, and a stone's throw away from GGP, this prime location is a must-see!
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T18:16:23.000+0000
pba__latitude_pb__c, 37.7603892
pba__latitude_property__c, 37.7603892
laundry_features__c, Laundry Closet
listed_date__c, 2023-01-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Simon
pba__listing_agent_lastname__c, Shue
listing_agent_mls_id__c, 807897
ffd_listingagentname, Simon C Shue
listing_agent_number__c, 1028279
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 2288888
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4878845
lower_level__c, Bedroom(s),Dining Room,Full Bath(s),Garage,Kitchen,Living Room,Primary Bedroom
mls_id__c, 423715395
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Tile;Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-20
original_price__c, 2288888
overall_days_on_market__c, -81468
parking_access__c, Independent
parking_features__c, Attached,Covered,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2023-02-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 973.52
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a7n56UAA
room_type__c, In Law Apartment;Guest Quarters;Primary Bedroom 2+
sale_date__c, 2023-03-03
sale_price__c, 2169000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 202640
selling_agent_number__c, 202640
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Merchant Real Estate, Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 2228
size__c, 2228
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 29th
subdist__c, Central Sunset
ffd_name, 1443 29th Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
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/530569094-1.jpg