meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217772' 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, 2251 Moraga Street, San Francisco, CA, 94122
ffd_mls_id, 421529303
ffd_salesforce_id, a0E1I00000Tx8TeUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 8
of_units__c, 0
address2__c, 2251 Moraga Street, San Francisco, CA, 94122
pba__address_pb__c, 2251 Moraga Street, San Francisco, CA, 94122
agent_only_remarks__c, Sunset Hidden Gem,this large two level mid century modern home sits on the corner of Moraga and 29th Ave. Complete with new interior paint, low flush toilets, refinished hardwood floors, two year old roof and exterior paint. The street level has a very large two car garage with an entrance to the studio in law unit with a kitchenette. Seperate entrance off of 29th Ave. An income generating unit,an office or a space for the live in nanny. The mainlevel boasts a large entry with original hard wood flooring and crystal chandelier. The large living room and formal dining room allow for natural light throughout. The kitchen has a sun filled breakfast nook from which to enjoy that morning cup of coffee and the Sunday paper. From the grand staircase you reach the second level, Two bedrooms, a bathroom and a master bedroom with a full bathroom. Off of the master bedroom is a small deck to enjoy the view of Mt Tamalpais and the tips of the GG Bridge. Walkscore of 89. Community center across the street,Ocean Beach & GG park nearby. Escro@ CTT w/ Gerrie Brindley.For appt- https://calendly.com/dearmangroup/2251-moraga-street-showings. send PEAD I will provide code. Disclosures:https:https://app.disclosures.io/link/2251-Moraga-Street-efxzu1q2 offers due 3/31/21 by 3PM.
appliances__c, Dishwasher;Gas Water Heater;Hood Over Range;Free Standing Electric Oven;Free Standing Electric Range
architectural_style__c, Mid-Century
bath_features__c, Tub w/Shower Over;Tile;Dual Flush Toilet;Window
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-03-24T16:33:52.000+0000
days_on_market__c, 847
dom__c, 6
ffd_description_pb, Come see this Hidden Gem! A large two level mid century modern home sits on the corner of Moraga and 29th Ave. Complete with new interior paint, low flush toilets, refinished hardwood floors, two year old roof and new exterior paint. The street level has a very large two car garage with a back entrance to the studio in law unit with a kitchenette and windows off to the back yard. This can be an income generating unit,an office or a space for the live in nanny.The main level boasts a large entry with original hard wood flooring and crystal chandelier. The large living room and formal dining room allow for natural light throughout. The kitchen has a sun filled breakfast nook from which to enjoy that morning cup of coffee and the Sunday paper. It is from the grand staircase that you reach the second level, Two large bedrooms, a bathroom and a master bedroom with a full bathroom. Off of the master bedroom is a small deck to enjoy the view of Mt. Tamalpais and the tips of the GG bridge
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Tile;Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas;Fireplace(s)
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:47:39.000+0000
pba__latitude_pb__c, 37.7554657
pba__latitude_property__c, 37.7554657
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2021-02-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tracy
pba__listing_agent_lastname__c, Dearman
listing_agent_mls_id__c, 807444
ffd_listingagentname, Tracy I Dearman
listing_agent_number__c, 1018468
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, KWRSF
listing_office_name__c, Keller Williams San Francisco
listing_office_number__c, 26158
pba__listingprice_pb__c, 1799000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=kVnKBxCQytv
pba__longitude_pb__c, -122.4871208
lower_level__c, Garage,Street Entrance
mls_id__c, 421529303
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Tile;Window;Dual Flush Toilet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-03-24
original_price__c, 1799000
overall_days_on_market__c, 68
parking_access__c, Side by Side
parking_features__c, Attached,Covered,Enclosed,Garage Facing Front,Side-by-Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-03-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 727.99
pba__propertytype__c, Single Family Residence
id, a0E1I00000Tx8TeUAJ
road_surface_type__c, Asphalt,Paved
room_type__c, Laundry;Kitchen;In Law Apartment;Living Room;Master Bathroom;Dining Room;Master Bedroom
sale_date__c, 2021-04-26
sale_price__c, 2200000
security_features__c, Security Gate
selling_agent_mls_id__c, 804303
selling_agent_number__c, 166013815
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Inspire Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 3022
size__c, 3022
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Moraga
subdist__c, Central Sunset
ffd_name, 2251 Moraga Street, San Francisco, CA, 94122
view__c, Ocean;Park;Golden Gate Bridge;Hills
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Screens;Caulked/Sealed
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530203101-1.jpg
ListingId, a0E1I00000Tx8TeUAJ