meta_query='key:subdist__c;value:Westwood Highlands|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='424441' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70668
[post_author] => 4
[post_date] => 2018-11-30 20:30:43
[post_date_gmt] => 2018-11-30 20:30:43
[post_content] => Stately single-family homes with views to the southwest at the base of Mt. Davidson define this West of Twin Peaks classic. Like its adjacent neighbors, it assumes you've got a car to get you to and from some jaw-dropping views.
[post_title] => Westwood Highlands
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => westwood-highlands
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 11:34:43
[post_modified_gmt] => 2024-11-21 19:34:43
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70668
[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, 1739974835
ffd_listing_title, 310 Colon Avenue, San Francisco, CA, 94127
ffd_mls_id, 425003979
ffd_salesforce_id, a0EUd00000450GRMAY
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
pba__address_pb__c, 310 Colon Avenue, San Francisco, CA, 94127
address2__c, 310 Colon Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Offer deadline is Wed 1/29 @ 9AM. Pls allow 48 hrs for sellers to respond as they live out of the country. No pre-emptive offers please. Sq footage in tax records is 1,555. Graphic artist measured 1,655 on main level and an additional 240 sq feet downstairs (room and bath which are unwarranted). Buyers must use SFAR contract and all offers must include signed cover page of disc pkg and pre-approval / POF with your offer. Very easy to show - call agent for access. Disclosures and full reports available here: https://app.disclosures.io/link/310-Colon-Avenue-o1wlr4m3
appliances__c, Microwave;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator;Gas Cook Top
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1925
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Stefano Dezerega
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-01-17T19:48:19.000+0000
days_on_market__c, 33
dom__c, 13
ffd_description_pb, Fully detached 1925 storybook Tudor-style Westwood Highlands home. Bathed in natural light, this residence blends elegant period details with modern updates and improvements. Great curb appeal. Lush front yard & flagstone pathway beckons the visitor, signaling you are about to enter a very special home. Entrance foyer with built-in cabinetry. Gracious living room with dramatic vaulted ceiling, tall bay windows, wide tiled fireplace and built-in cabinets. Spacious formal dining room with buffet adjacent to a remodeled kitchen and a separate breakfast nook that could work as an office. There are three spacious bedrooms and a remodeled bathroom on this same level - an ideal layout. Additional room downstairs with ensuite bathroom works perfectly as a home office or guest room. Large garage and basement offers potential expansion options and lots of storage. Serene and secluded yard, fenced with mature plantings. Space for multiple cars in the driveway and one in the garage. Easy access to BART and nearby freeway makes travel to airport or downtown a breeze. Prestigious Westwood Highlands boasts classic architecture and is conveniently located an equal distance from the attractive commercial districts of Glen Park and West Portal.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__hoafees__c, 25
pba__hoafrequency_pb__c, Annually
hoa_name__c, Westwood Highlands Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Cathedral Ceiling
ffd_lastmodifieddate, 2025-02-19T13:47:25.000+0000
pba__latitude_pb__c, 37.7315799
pba__latitude_property__c, 37.7315799
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2025-01-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Hugh
pba__listing_agent_lastname__c, Groocock
listing_agent_mls_id__c, 515087
ffd_listingagentname, Hugh D Groocock
listing_agent_number__c, 515087
listing_co_agent_mls_id__c, 805631
listing_co_agent_number__c, 166015627
listing_co_office_mls_id__c, CIP01
listing_co_office_name__c, Corcoran Icon Properties
listing_co_office_number__c, 28939
listing_office_mls_id__c, CIP01
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28939
pba__listingprice_pb__c, 1895000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=8QGdtKtP12u&brand=0
pba__longitude_pb__c, -122.4564325
mls_id__c, 425003979
master_bathroom_features__c, Shower Stall(s);Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2025-01-17
original_price__c, 1895000
overall_days_on_market__c, -82196
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2025-01-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 2025-02-18T22:18:39.000+0000
price_per_square_foot__c, 1479.1
pba__propertytype__c, Single Family Residence
ListingId, a0EUd00000450GRMAY
sale_date__c, 2025-02-18
sale_price__c, 2300000
selling_agent_mls_id__c, 810551
selling_agent_number__c, 1046889
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Chance Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1555
size__c, 1555
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Colon
subdist__c, Westwood Highlands
ffd_name, 310 Colon Avenue, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530932285-1.jpg