meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385898' 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
(
)
)
_yoast_indexnow_last_ping, 1726451560
ffd_listing_title, 1727 Judah Street, San Francisco, CA, 94122
ffd_mls_id, 424062360
ffd_salesforce_id, a0EUd0000033D0dMAE
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 1727 Judah Street, San Francisco, CA, 94122
pba__address_pb__c, 1727 Judah Street, San Francisco, CA, 94122
agent_only_remarks__c, Offers due Wednesday 9/18 at 11:00. SFAR Purchase contract only. Preliminary Title #0216039616 opened with Janette Marcelo, Old Republic Title, 415-354-7581.
appliances__c, Dishwasher
architectural_style__c, Marina;Spanish
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1935
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Susie Smith
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-06T21:47:56.000+0000
days_on_market__c, 9
dom__c, 9
ffd_description_pb, Remodeled Marina style 3 bedroom, 2 bath home with Spanish influence conveniently located in suburban Central Sunset. The ideal location is just one block to Irving commercial district and a stone's throw to the N Judah Line stretching from Ocean Beach to the Embarcadero. Just 3 blocks to Golden Gate Park the area is walkable and bike/car friendly with a substantial and spacious garage. A sunny center patio floods natural light into the living room and remodeled kitchen with all new appliances. . Enjoy meals at the bar or in your formal dining room. Upstairs has two bedrooms and a remodeled full bath. Downstairs is an oversized suite with access to a large flat backyard awaiting your personal touch!
district__c, SF District 2
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Brick
pba__floortype_pb__c, Laminate;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2024-09-16T01:46:44.000+0000
pba__latitude_pb__c, 37.7613467
pba__latitude_property__c, 37.7613467
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2024-08-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Eggert
listing_agent_mls_id__c, 808081
ffd_listingagentname, John W Eggert
listing_agent_number__c, 1030502
listing_co_agent_mls_id__c, 807777
listing_co_agent_number__c, 1025966
listing_co_office_mls_id__c, CIP
listing_co_office_name__c, Corcoran Icon Properties
listing_co_office_number__c, 28936
listing_office_mls_id__c, CIP
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28936
pba__listingprice_pb__c, 1398000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.480753
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 424062360
main_level__c, Bedroom(s);Kitchen;Living Room;Family Room
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-09-06
open_house_end__c, 2024-09-15T16:00:00.000+0000
open_house_start__c, 2024-09-15T14:00:00.000+0000
original_price__c, 1398000
overall_days_on_market__c, -82063
parking_access__c, Tandem
parking_features__c, Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 802.99
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000033D0dMAE
roof__c, Tar/Gravel;Tile
room_type__c, Kitchen;Dining Room;Primary Bedroom 2+
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1741
size__c, 1741
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Judah
subdist__c, Central Sunset
ffd_name, 1727 Judah Street, San Francisco, CA, 94122
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1935
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530837979-1.jpg