meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217168' 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, 1727 29th Avenue, San Francisco, CA, 94122
ffd_mls_id, 421520225
ffd_salesforce_id, a0E1I00000TvwU1UAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 1727 29th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1727 29th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, To schedule private showings, go to - https://calendly.com/dennisotto/1727-29th-avenue-private-showing?month=2021-02 Disclosures can be viewed at - https://app.disclosures.io/link/1727-29th-Avenue-ernvdvrh Offers to be reviewed on Weds 2/24 at 1pm. Seller is a licensed CA real estate agent.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Double Oven;Ice Maker
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1939
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Dennis R Otto
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-02-17T09:17:27.000+0000
days_on_market__c, 883
dom__c, 9
ffd_description_pb, This modern, 4-bedroom, 3.5 bath, home has been modernized to the highest standards. The bright living area, has vaulted ceilings, a gas fireplace, and built-ins, while French doors open to the balcony and views of the GG Bridge. The open plan flows into the dining area and beyond to the kitchen. The kitchen has multiple skylights, an island, and professional-grade appliances. A half-bath is located off the hall leading to the primary bedroom and office. The large bedroom has a walk-in closet, a dedicated spa-like bath, French doors, and balcony. The garden level has 3 bedrooms, two sharing the hall bath, while the third, with outdoor access, has a private bath. Laundry and access to the 2-car garage complete this level. The back patio is spacious, and the upper terrace has turf and an art studio/playroom. The finished garage includes rubber flooring and storage. Radiant heat, double-paned windows, built-in sound system, solar panels, and quality window coverings are included.
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Wood
fireplace_features__c, Living Room;Gas Piped
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, Hot Water;Radiant
interior_features__c, Cathedral Ceiling
ffd_lastmodifieddate, 2022-01-25T15:45:09.000+0000
pba__latitude_pb__c, 37.755068
pba__latitude_property__c, 37.755068
laundry_features__c, Inside Area;Washer Included;Dryer Included
listed_date__c, 2021-02-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lee Ann
pba__listing_agent_lastname__c, Monfredini
listing_agent_mls_id__c, 803778
ffd_listingagentname, Lee Ann Monfredini
listing_agent_number__c, 803778
listing_co_agent_mls_id__c, 803441
listing_co_agent_number__c, 803441
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1998000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=ntB37dRu431&hl=0
pba__longitude_pb__c, -122.487595
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 421520225
main_level__c, Full Bath(s);Master Bedroom;Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Quartz;Double Sinks;Tile;Jetted Tub;Radiant Heat;Steam
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-02-16
original_price__c, 1998000
overall_days_on_market__c, 104
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2021-02-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 972.87
pba__propertytype__c, Single Family Residence
id, a0E1I00000TvwU1UAJ
roof__c, Composition
room_type__c, Office;Master Bathroom;Dining Room;Master Bedroom
sale_date__c, 2021-03-24
sale_price__c, 2510000
selling_agent_mls_id__c, 814683
selling_agent_number__c, 1067836
selling_co_agent_mls_id__c, 809137
selling_co_agent_number__c, 1040715
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2580
size__c, 2580
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 29th
subdist__c, Central Sunset
ffd_name, 1727 29th Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Coverings;Window Screens
pba__yearbuilt_pb__c, 1939
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530184163-1.jpg
ListingId, a0E1I00000TvwU1UAJ