meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='213672' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15735
[post_author] => 4
[post_date] => 2018-11-02 20:00:49
[post_date_gmt] => 2018-11-02 20:00:49
[post_content] => Balboa Park BART. Single-family homeowners shuttling south to Silicon Valley or BARTing to downtown and points east. Balboa Park. An urban delight with an indoor swimming pool, outdoor ball fields, and a great playground. Ocean Avenue boutiques, grocery stores, restaurants, and more are a quick meander away.
[post_title] => Mission Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-terrace
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-12 12:23:14
[post_modified_gmt] => 2024-04-12 19:23:14
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15735
[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, 8 Colonial Way #4, San Francisco, CA, 94112
ffd_mls_id, 502491
ffd_salesforce_id, a0E1I00000S121WUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 10
address2__c, 8 Colonial Way #4, San Francisco, CA, 94112
pba__address_pb__c, 8 Colonial Way #4, San Francisco, CA, 94112
agent_only_remarks__c, Check out www.GrandMissionTerraceCondo.com Transparent pricing! Sq. ft. per appraisal 1884, Tax record 1612 sq. ft. Seller requests a 30 day rent back. Easy to show- best times are weekdays after 4 and weekends.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2003
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Steve M Dells
pba__contingentdate__c, 2020-10-17
ffd_createddate, 2020-08-12T16:48:32.000+0000
days_on_market__c, 1084
dom__c, 99
ffd_description_pb, You won't believe the size & spaciousness of this light filled house-like corner condominium, well located in desirable Mission Terrace.All on one level, there are hardwood floors, gas fireplace and expansive corner windows.You'll love cooking in the large kitchen with lots of counter space(granite) + wood cabinets.All 3 bedrooms are generous & have double closets w/custom built-ins.The master bedroom suite has a small balcony and a spacious bathroom w/double sinks & separate tub. The premiere condo complex in Mission Terrace, steps from Balboa Park, great for dogs, plus a playground, tennis courts and swimming pool! Built in 2003, this close-knit community enjoys the cafe downstairs plus dry-cleaners and market across the street.Steps to the J-Muni car, an easy walk to Glen Park or Balboa Park BART stations.Minutes to the 101-280 freeway and under 15 minutes to SFO! Close to the great commercial districts in Glen Park,Bernal Hts+Noe Valley.Easy to show by appointment w/24hour notice
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Shared Driveway
entry_level__c, 2
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped;Gas Starter
pba__floor__c, 2
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_dues__c, 616
hoa_fee_includes__c, Management,Trash,Homeowners Insurance,Water
pba__hoafees__c, 616
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:29:31.000+0000
pba__latitude_pb__c, 37.7286913
pba__latitude_property__c, 37.7286913
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-07-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Debbie
pba__listing_agent_lastname__c, Dells
listing_agent_mls_id__c, 806226
ffd_listingagentname, Debbie G Dells
listing_agent_number__c, 166016573
listing_co_agent_mls_id__c, 221553
listing_co_agent_number__c, 221553
listing_co_office_mls_id__c, CGL
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28240
listing_office_mls_id__c, CGL
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28240
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/442507871
pba__longitude_pb__c, -122.440595
pba__lotsize_pb__c, 0
mls_id__c, 502491
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s)
master_bathroom_features__c, Tub
master_property__c, a0O1I000004VYViUAO
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-07-30
original_price__c, 950000
overall_days_on_market__c, 134
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-11-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 528.13
pba__propertytype__c, Condominium
id, a0E1I00000S121WUAR
sale_date__c, 2020-11-19
sale_price__c, 995000
selling_agent_mls_id__c, 812604
selling_agent_name__c, Kseniya Kurkina
selling_agent_number__c, 1057286
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1884
size__c, 1884
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Colonial
subdist__c, Mission Terrace
ffd_name, 8 Colonial Way #4, San Francisco, CA, 94112
transportation__c, 1 Block
unit_number__c, 4
view__c, Hills
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2003
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/367237-1.jpg
ListingId, a0E1I00000S121WUAR