WITH SpatialFiltered AS ( SELECT g.mls, g.lat, g.lon FROM zfc90961_properties.geocodes g WHERE (g.lat BETWEEN '28.575536726966792' - (15 / 111.045) AND '28.575536726966792' + (15 / 111.045)) AND (g.lon BETWEEN '-80.81124170185313' - (15 / 111.045) AND '-80.81124170185313' + (15 / 111.045)) AND ST_Within(POINT(g.lat, g.lon), ST_GeomFromText('Polygon((28.578936335311933 -80.81842123016018, 28.571832191797032 -80.81827102645535, 28.571737969163483 -80.81427453502316, 28.568265806271437 -80.81436036571164, 28.56828465142677 -80.80889938815731, 28.568312919153456 -80.8089315746655, 28.570187994730873 -80.80889938815731, 28.570291641150014 -80.8084273193707, 28.57055546793805 -80.80798743709225, 28.572932234801087 -80.8063566540112, 28.572995834366246 -80.80631910308499, 28.572992301058154 -80.8061595116486, 28.572965212358433 -80.80597309812207, 28.572914568248812 -80.80545140846867, 28.572865690771017 -80.80533540292878, 28.57277912457996 -80.80523012622494, 28.5729628568191 -80.80446033223767, 28.576397177308067 -80.80508528693814, 28.578837408226953 -80.80551980479855, 28.58266252114215 -80.80616353496212, 28.582690785005553 -80.81225214942593, 28.578882160967375 -80.8123540733685, 28.578936335311933 -80.81842123016018))')) )SELECT p.ListOfficeMlsId, p.LotSizeSquareFeet, p.LotSizeAcres, p.OriginatingSystemName, p.PropertySubType, p.ListPrice, p.OriginalListPrice, p.MlsStatus, p.ListingId, p.UnparsedAddress, p.City, p.PostalCode, p.BedroomsTotal, p.BathroomsTotalInteger, p.GarageSpaces, p.BuildingAreaTotal, p.LivingArea, p.PoolPrivateYN, p.WaterfrontYN, p.WaterfrontFeatures, CASE WHEN p.CumulativeDaysOnMarket IS NOT NULL AND p.DaysOnMarketReplicationDate IS NOT NULL THEN (p.CumulativeDaysOnMarket + DATEDIFF(NOW(), p.DaysOnMarketReplicationDate)) ELSE DATEDIFF(NOW(), p.OnMarketDate) END AS DOM, p.listing_updated_timestamp, sf.lat, sf.lon, p.PhotosCount FROM zfc90961_properties.reso_property p JOIN SpatialFiltered sf ON p.listingid = sf.mls WHERE p.PropertyType IN('Residential') AND `PropertySubType` IN('Condominium') ORDER BY FIELD(ListOfficeMlsId, '276644486','MFR276644486', 'ZFCR01') DESC, `ListPrice` + 0 DESC La Cita Country Club Condos For Sale in Titusville, FL

La Cita Country Club

In This Community
Get alerted to new listings and price drops in this location!
Email Me Alerts for La Cita Country Club

La Cita Country Club Condos For Sale

585 Shadow Wood Lane 125, Titusville
$274,000

MLS#1075076

585 Shadow Wood Ln 125
Titusville, FL 32780

3

3

2,436 Sq Ft

0.03 Acres

4 Days

3505 Sable Palm Lane F, Titusville
Reduced
$245,000
$257,000

MLS#1064761

3505 Sable Palm Ln F
Titusville, FL 32780

3

2

1,078 Sq Ft

0.06 Acres

143 Days

1147 Country Club Drive 1021, Titusville
$199,000

MLS#1076710

1147 Country Club Drive 1021
Titusville, FL 32780

2

2

920 Sq Ft

0.05 Acres

5 Days

3580 Sable Palm Lane C, Titusville
Reduced
$185,000
$195,000

MLS#1065129

3580 Sable Palm Ln C
Titusville, FL 32780

2

2

840 Sq Ft

0.07 Acres

133 Days

1055 Country Club Drive 523, Titusville
Reduced
$183,900
$185,000

MLS#1072449

1055 Country Club Drive 523
Titusville, FL 32780

2

2

1,020 Sq Ft

0.06 Acres

53 Days

1087 Country Club Drive 721, Titusville
Reduced
$175,000
$195,000

MLS#1063494

1087 Country Club Drive 721
Titusville, FL 32780

2

2

940 Sq Ft

0.05 Acres

7 Days

1089 Country Club Drive 722, Titusville
Under Contract
$170,000

MLS#1076092

1089 Country Club Drive 722
Titusville, FL 32780

2

2

940 Sq Ft

0.05 Acres

11 Days

1127 Country Club Drive 921, Titusville
Under Contract
$170,000
$225,000

MLS#1034326

1127 Country Club Drive 921
Titusville, FL 32780

2

2

940 Sq Ft

Pool

0.05 Acres

41 Days

3585 Sable Palm Lane E, Titusville
$149,900

MLS#1067062

3585 Sable Palm Ln E
Titusville, FL 32780

2

1

785 Sq Ft

0.07 Acres

112 Days

3555 Sable Palm Lane 7f, Titusville
$144,900

MLS#1068904

3555 Sable Palm Ln 7f
Titusville, FL 32780

2

2

864 Sq Ft

13.53 Acres

92 Days

3515 Sable Palm Lane B, Titusville
Reduced
$135,000
$149,000

MLS#1069854

3515 Sable Palm Ln B
Titusville, FL 32780

2

2

864 Sq Ft

0.06 Acres

81 Days

3555 Sable Palm Lane B, Titusville
Reduced
$134,900
$140,000

MLS#1068557

3555 Sable Palm Ln B
Titusville, FL 32780

2

2

864 Sq Ft

0.07 Acres

96 Days

Other La Cita Country Club listings
Homes Townhouses

What schools are La Cita Country Club condos zoned for?

Where you live in Titusville determines which public schools your children may attend, which directly influences condo values. La Cita Country Club condominiums are zoned for the following Brevard County school districts, making school zone boundaries a key factor in property desirability and market demand.

The data relating to homes for sale or lease or other real estate for sale or for rent on the ZFC website comes in part from a cooperative data exchange program of the MLS in which this Broker participates. The real estate displayed may not be all of the homes in the database, or all of the properties listed with Brokers participating in the cooperative data exchange program. Homes for sale that are listed by Brokers other than this Broker are marked with either the listing Broker's name or the MLS name or a logo provided by the MLS and the details page about such properties includes the name of the listing Brokers. Information provided is thought to be reliable but is not guaranteed to be accurate; you are advised to verify facts that are important to you. No warranties, expressed or implied, are provided for the data herein, or for their use or interpretation by the user. ZFC, the Florida Association of Realtors and its cooperating Multiple Listing Services do not create, control or review the property data displayed herein and take no responsibility for the content of such records. Federal law including the fair housing act prohibits discrimination on the basis of race, color, religion, sex, handicap, familial status or national origin in the sale, rental or financing of housing. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

FILTERS ^
Currency
USD CAD EUR GBP BTC