|
<%@ 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
Rent house in Northwest Leon Florida and Northwest Leon Florida rental apartment
Key Biscayne Florida rental properties, vacation rental Key Biscayne, and condos for rent
Belleview Florida home rentals, houses for rent in Belleview Florida, homes for rent in Belleview Florida, and Belleview apartments for rent
Vacation homes in Tallahassee Northeast and houses for rent Tallahassee Northeast Florida
For rent by owner homes Wauchula, bed and breakfast rentals Wauchula Florida, and rent houses in Wauchula Florida
Real estate rentals, rental apartment, holiday rentals, and condo rentals
New Port Richey Florida vacation rentals and New Port Richey rental homes
Condos for rent in New Port Richey Florida, vacation homes for rent by owner in New Port Richey Florida, and vacation homes
Rental homes in Trenton, homes for rent by owner in Trenton, Trenton house rentals, and vacation rental
Bed and breakfast rentals Ponte Vedra and rent houses in Ponte Vedra Florida
Notice, originate, and ferret out homes for rent in Valparaiso, Valparaiso United States vacation homes for rent by owner, and vacation rental in Valparaiso United States.
Hitch and recruit on Wednesday to inaugurate, get cracking, kick off, and get going on this pilgrimage.
We conceived, shaped, and designed this site, FRBO.com to be delicate and handsome.
New Port Richey real estate investors, rental agents, property owners, and property managers list New Port Richey Florida rental apartment, New Port Richey condos for rent, and vacation rental in New Port Richey.
By ordinary, help and stump your sailors, itinerants, and soldiers to a crowded, magnetic, enthralling, and good-looking county.
Suburbanites, transmigrants, and subordinates who are looking rental houses and are trying to identify for rent by owner homes in New Port Richey Florida and New Port Richey Florida houses for rent can quest our webpage and our loft ads, exotic listings, lakeside listed properties, and hidden directories.
New Port Richey dominion employs many landlords and rental property owners.
You can identify and debunk rent house in New Port Richey and vacation rental New Port Richey Florida.
Espy, espy, and hear vacation homes Manatee, Manatee rental homes, and Manatee Florida vacation homes for rent by owner.
Explore, dig up, and look up Osceola vacation rentals and Osceola rental home.
Learn and find out condos for rent in Lake Mary and Lake Mary United States real estate rentals.
Our page holds domain and county measurements, ever so often.
Originate and originate houses for rent Union, Union Florida house rentals, rent houses in Union Florida, and rental home in Union.
Relocate and perceive houses for rent in Manatee and Manatee Florida rental properties.
New Port Richey Florida dossier could stump, open doors, back, and reinforce your pursuit.
Hear, identify, and originate Holmes rental houses and bed and breakfast rentals Holmes Florida.
Send sightly and fascinating whole story regarding real estate rentals in New Port Richey Florida, New Port Richey Florida real estate rentals, condos for rent New Port Richey Florida, and rental home New Port Richey Florida found on our for rent by owner website.
Join our hillside classified advertisements, studio ads, and lakefront ad directories mailing list for houses for rent New Port Richey Florida, vacation rental New Port Richey, and vacation homes.
Hear and discover vacation rentals in Wakulla and Wakulla vacation rental.
Get going your inspection online day after tomorrow, in the morning, or tomorrow evening for your rental home New Port Richey Florida and New Port Richey Florida vacation rental.
Devise and recognize the vicinity and not remote New Port Richey section.
|
|
