|
<%@ 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
Interlachen-Florahome Florida rental houses and Interlachen-Florahome vacation homes for rent by owner
Frostproof Florida apartment rentals, Frostproof Florida apartments for rent, and Frostproof Florida rental properties
Homes for rent by owner Freeport, homes for rent, Freeport condos for rent, and rent houses Freeport Florida
Port Richey homes for rent by owner and vacation rentals in Port Richey Florida
Rental houses, Daytona Beach Florida vacation homes, and Daytona Beach vacation homes for rent by owner
Apartments for rent in Tallahassee Northwest Florida, Tallahassee Northwest rental houses, homes for rent Tallahassee Northwest, and Tallahassee Northwest Florida short term rentals
For rent by owner homes Boca Ciega Florida and vacation homes for rent by owner in Boca Ciega
St Petersburg Florida rental apartment, real estate rentals in St Petersburg Florida, and St Petersburg vacation rentals
Middleburg-Clay Hill Florida rental houses, condo rentals Middleburg-Clay Hill Florida, Middleburg-Clay Hill Florida rental properties, and houses for rent in Middleburg-Clay Hill
Rental properties Tallahassee South and Tallahassee South Florida rental houses
Vacation rentals Leesburg East Florida, vacation rental in Leesburg East, and Leesburg East Florida home rentals
Real estate rentals Haines City Florida, Haines City Florida rental homes, home rentals Haines City, and houses for rent in Haines City Florida
Home rentals in Kendale Lakes-Lindgren Acres Florida and vacation rentals in Kendale Lakes-Lindgren Acres Florida
Zephyrhills vacation rentals, home rentals in Zephyrhills Florida, and Zephyrhills bed and breakfast rentals
Leesburg Florida rent house, vacation homes for rent by owner in Leesburg Florida, apartment rentals Leesburg, and homes for rent by owner Leesburg
Homes for rent by owner Boca Ciega Florida and homes for rent by owner Boca Ciega Florida
Homes for rent by owner in Marianna Florida, Marianna Florida vacation homes for rent by owner, and for rent by owner homes in Marianna Florida
Rental home in Howey-in-the-Hills-Okahumpka, Howey-in-the-Hills-Okahumpka Florida rent houses, Howey-in-the-Hills-Okahumpka vacation homes for rent by owner, and Howey-in-the-Hills-Okahumpka Florida houses for rent
Real estate rentals in Miami Beach and real estate rentals in Miami Beach Florida
Orange Park Florida rent house, rent house Orange Park, and rental houses in Orange Park Florida
Vacation homes in St Augustine, St Augustine Florida apartment rentals, real estate rentals in St Augustine, and apartments for rent in St Augustine Florida
Indialantic-Melbourne Beach Florida vacation homes for rent by owner and Indialantic-Melbourne Beach Florida house rentals
Vernon Florida rental houses, vacation homes in Vernon Florida, and real estate rentals Vernon Florida
Lynn Haven Florida home rentals, rent house in Lynn Haven Florida, house rentals in Lynn Haven Florida, and home rentals Lynn Haven
Glimpse and explore rental properties Leon, Leon Florida rent house, and real estate rentals Leon.
Cocoa Beach-Cape Canaveral third party agents, real estate investors, land owners, and home owners list vacation rentals in Cocoa Beach-Cape Canaveral, Cocoa Beach-Cape Canaveral rental houses, real estate rentals in Cocoa Beach-Cape Canaveral Florida, and rental properties in Cocoa Beach-Cape Canaveral Florida.
Originate and devise vacation rentals Columbia Florida and short term rentals Columbia Florida.
Travelers, rent payers, and roamers who are exploring Cocoa Beach-Cape Canaveral Florida short term rentals and are trying to originate bed and breakfast rentals Cocoa Beach-Cape Canaveral Florida and Cocoa Beach-Cape Canaveral Florida rental home can investigate this extensive website, FRBO.com and our hidden ads, beach lists of marked properties, suburban advertisements, and suburban listed properties.
Come across, dig up, and light upon rental homes Bay Florida and Bay Florida apartments for rent.
Notice, contrive, and ascertain houses for rent in Webster, house rentals, and homes for rent by owner.
Originate your quest online next weekend or in the next few days for your bed and breakfast rentals Cocoa Beach-Cape Canaveral and apartments for rent in Cocoa Beach-Cape Canaveral.
Detect and uncover rental homes Liberty, for rent by owner homes in Liberty Florida, vacation rental Liberty, and rental apartment Liberty Florida.
Identify and uncover Lake Helen United States apartments for rent and houses for rent in Lake Helen.
Contrive, determine, and espy rental houses in Immokalee, vacation homes in Immokalee United States, and Immokalee United States vacation homes.
Cocoa Beach-Cape Canaveral Florida section employs many property owners, home owners, agents serving the condo market, and condo owners.
Our webpage does comprise sundry sector lakefront, resort, romantic, and rustic duplex, hacienda, and townhouses.
See resort classified ads and log classifieds that agents serving the condo market and property agents post on our page.
Uncover, notice, and relocate houses for rent Apopka United States, Apopka rental home, and vacation rentals.
Chatham New Jersey rental homes, Chatham rental properties, vacation homes for rent by owner Chatham New Jersey, and apartments for rent in Chatham
Look up and light upon Bay rent houses and rental home in Bay Florida.
The Cocoa Beach-Cape Canaveral Florida secluded listed properties, exclusive lists of marked properties, and beachfront advertisements for these zone can be mapped.
Look up, look up, and espy rental home Palmetto, rental apartment in Palmetto United States, and rental home Palmetto United States.
Find, determine, and come upon the state and not faraway Cocoa Beach-Cape Canaveral Florida turf.
Invent, come upon, and locate home rentals, real estate rentals in Fruitland Park, and rental houses Fruitland Park United States.
Find out and espy homes for rent and apartment rentals.
Entrepreneurs, globetrotters, and householders who are wishing to learn, discern, and distinguish or simply observe information can use For Rent By Owner.
Look up and locate rental homes and apartments for rent Palatka.
Join our beach indexes, private classifieds, and ski in/out ads mailing list for vacation homes in Cocoa Beach-Cape Canaveral Florida and vacation homes for rent by owner Cocoa Beach-Cape Canaveral Florida.
You can look over the exotic lists of marked properties, well appointed online MLS, loft listings, and beachfront classified ads under vacation rentals, apartments for rent in Cocoa Beach-Cape Canaveral, and short term rentals.
|
|
