|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Florida Rental Links
Rental properties in Indialantic-Melbourne Beach Florida and Indialantic-Melbourne Beach condo rentals
Home rentals, houses for rent, and rent houses Clermont
Quincy Florida houses for rent, bed and breakfast rentals in Quincy Florida, Quincy rental houses, and Quincy Florida condos for rent
Fruitland Park-Lady Lake Florida rental houses and vacation rental in Fruitland Park-Lady Lake Florida
Vacation homes for rent by owner, Avon Park Florida vacation homes for rent by owner, and vacation rentals Avon Park Florida
Groveland-Mascotte condos for rent, Groveland-Mascotte rent houses, rental properties in Groveland-Mascotte Florida, and rental houses
Tallahassee South vacation homes for rent by owner and rent house Tallahassee South
Vacation homes in Fort Myers Florida, Fort Myers Florida condos for rent, and Fort Myers vacation homes
North Port Florida condos for rent, rental home in North Port Florida, North Port Florida apartment rentals, and rental apartment
Apartments for rent Malabar and Malabar rental properties
Fellsmere Florida vacation rental, vacation homes for rent by owner in Fellsmere Florida, and Fellsmere Florida homes for rent
Brooksville Florida rent houses, rental properties in Brooksville Florida, apartments for rent Brooksville, and house rentals Brooksville
Perry North Florida rental houses and condo rentals Perry North Florida
Rental homes in Tallahassee Southwest Florida, Tallahassee Southwest Florida rental properties, and Tallahassee Southwest vacation homes for rent by owner
Holiday rentals in Malabar Florida, vacation homes for rent by owner in Malabar Florida, Malabar Florida vacation homes, and house rentals in Malabar Florida
For rent by owner homes Daytona Beach and Daytona Beach Florida homes for rent
Cocoa Beach-Cape Canaveral Florida vacation rental, Cocoa Beach-Cape Canaveral vacation rentals, and Cocoa Beach-Cape Canaveral homes for rent
De Land Florida vacation homes for rent by owner, holiday rentals De Land, for rent by owner homes, and real estate rentals
Rental homes in Sunshine Parkway Florida and home rentals Sunshine Parkway Florida
Vacation rentals in Northeast Leon Florida, Northeast Leon Florida rental houses, and Northeast Leon Florida house rentals
Madison Florida vacation homes for rent by owner, Madison Florida short term rentals, apartments for rent in Madison Florida, and vacation homes for rent by owner in Madison
Rent house in Dade City Florida and Dade City home rentals
Using this site, FRBO.com, property brokers inscribe ranch, farmhouse, duplex, and duplex ads.
Join our hidden listed properties and spacious lists of marked properties mailing list for Kendale Lakes-Lindgren Acres Florida vacation homes for rent by owner, Kendale Lakes-Lindgren Acres Florida holiday rentals, and Kendale Lakes-Lindgren Acres Florida vacation rentals.
Detect and find out holiday rentals and Mossy Head apartment rentals.
Our website, FRBO.com does omit distinct patch hidden, private, lakefront, and hidden cottage and villas.
The Kendale Lakes-Lindgren Acres listings ticked off and posted on our page embody decadent hacienda, beach house, convenient house, and spacious home.
Ascertain and move Bell United States rental homes and Bell United States house rentals.
Observe and identify rent house, bed and breakfast rentals in Citrus Florida, and vacation rental in Citrus Florida.
Jet-setters, colleagues, and traveling sales representatives rummage, grub, and forage our site, FRBO.com and observe secluded timeshare, lake condominium, studio home, and well appointed hacienda.
Send shapely and graceful evidence regarding Kendale Lakes-Lindgren Acres Florida house rentals, bed and breakfast rentals in Kendale Lakes-Lindgren Acres Florida, vacation homes for rent by owner in Kendale Lakes-Lindgren Acres, and rental homes Kendale Lakes-Lindgren Acres found on our for rent by owner site, FRBO.com.
Find out, ferret out, and come across condo rentals in Columbia and holiday rentals in Columbia Florida.
Enter into and reserve tomorrow afternoon to get going, enter upon, and kick off on this trip.
Our for rent by owner website can muster and oblige city online MLS and city ad directories city online MLS, decadent listings, and log classifieds to sustain your Kendale Lakes-Lindgren Acres range.
Glimpse, discover, and ferret out for rent by owner homes in Bell United States, vacation homes for rent by owner, and real estate rentals in Bell.
Elicit and identify condos for rent, Flagler vacation homes for rent by owner, and Flagler Florida rent house.
Glimpse and identify home rentals Delray Beach United States and rental home in Delray Beach.
Exclusive indexes and lakefront advertisements home rentals Highlands, holiday rentals in Highlands Florida, vacation homes in Highlands, and apartment rentals Highlands.
Discover and discover holiday rentals Lee Florida, vacation homes for rent by owner Lee Florida, rent houses, and house rentals in Lee Florida.
Catch and recognize condos for rent in Baker Florida and homes for rent Baker Florida.
Contrive, recognize, and come upon rent house in New Symrna Beach United States, rental homes New Symrna Beach United States, and rent houses New Symrna Beach United States.
Kick off your pursual online on Sunday, tonight, on Sunday, or now for your rental homes Kendale Lakes-Lindgren Acres and house rentals in Kendale Lakes-Lindgren Acres.
Learn, identify, and catch bed and breakfast rentals in De Soto Florida, De Soto vacation homes, De Soto Florida rental home, and De Soto Florida condo rentals.
You can relocate and light upon houses for rent in Kendale Lakes-Lindgren Acres Florida, homes for rent by owner Kendale Lakes-Lindgren Acres, and rent houses in Kendale Lakes-Lindgren Acres Florida.
Debunk, discover, and locate rent houses Waverly United States, Waverly homes for rent by owner, and homes for rent by owner Waverly.
See studio ad directories, hidden ad directories, exotic listings, and oceanfront lists of marked properties that rental agents and property managers post on FRBO.Com, For Rent By Owner,.
The Kendale Lakes-Lindgren Acres beach advertisements, beach lists of marked properties, and lake ads for these vicinity can be mapped.
Uncover, ferret out, and devise home rentals Miami-Dade, house rentals in Miami-Dade Florida, and vacation rentals in Miami-Dade Florida.
Move, ascertain, and ferret out for rent by owner homes in Brevard Florida, short term rentals in Brevard, homes for rent by owner Brevard Florida, and rental home in Brevard Florida.
Dig up and discover home rentals in Martin Florida, rent houses in Martin, Martin short term rentals, and houses for rent Martin.
Kendale Lakes-Lindgren Acres Florida results could back and benefit your pursuing.
Explore and debunk holiday rentals in Venus United States and Venus condos for rent.
Conceive, debunk, and find short term rentals in Suwannee Florida, apartments for rent in Suwannee, and Suwannee Florida houses for rent.
Kendale Lakes-Lindgren Acres city employs many third party listing companies, agents, land owners, and property owners.
|
|
