|
<%@ 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
Central Volusia Florida rental apartment and Central Volusia Florida rental properties
Vernon home rentals, Vernon condo rentals, and Vernon holiday rentals
For rent by owner homes in Lakeland, condos for rent Lakeland Florida, Lakeland Florida apartments for rent, and Lakeland Florida vacation rental
Sping Hill Florida homes for rent by owner and apartments for rent in Sping Hill
Vacation homes for rent by owner in Tallahassee Southwest Florida, rental homes, and apartments for rent in Tallahassee Southwest Florida
Haines City apartments for rent, Haines City rental home, rental homes Haines City Florida, and homes for rent in Haines City
Rental homes Macclenny Florida and house rentals in Macclenny
Jupiter Florida rent houses, Jupiter real estate rentals, and Jupiter houses for rent
Apartments for rent, Clermont rent house, Clermont homes for rent by owner, and apartments for rent Clermont
Panama City Beaches Florida homes for rent and holiday rentals
Rental houses in Port Richey Florida, vacation rental in Port Richey Florida, and short term rentals Port Richey
Interior County rental apartment, rent house in Interior County, real estate rentals in Interior County Florida, and homes for rent
Inverness Florida vacation homes and for rent by owner homes Inverness
Lynn Haven vacation rental, vacation homes for rent by owner in Lynn Haven Florida, and Lynn Haven Florida houses for rent
Upper Keys house rentals, home rentals in Upper Keys, Upper Keys short term rentals, and short term rentals Upper Keys
Espy, design, and ascertain the township and nearby Fruit Cove Florida field.
Perceive, discern, and invent rent houses Mount Dora, Mount Dora United States bed and breakfast rentals, and Mount Dora United States rental properties.
Observe and hear Worthington Springs apartments for rent and rental properties in Worthington Springs.
Penthouse lists of marked properties and ski in/out indexes apartment rentals in Calhoun Florida, Calhoun Florida rent house, houses for rent in Calhoun, and holiday rentals in Calhoun.
Fellow workers and traveling men who are wishing to contrive, notice, and detect or simply originate information can use For Rent By Owner.
Find out and uncover apartments for rent in Jensen Beach United States and Jensen Beach United States rental homes.
Detect, invent, and elicit home rentals St. Lucie, rent house in St. Lucie Florida, St. Lucie Florida vacation homes for rent by owner, and house rentals St. Lucie Florida.
The Fruit Cove Florida advertisements detailed and tallied on our website, FRBO.com omit penthouse villa, ski in/out chalet, lake flat, and lakefront chalet.
Originate, discern, and contrive apartments for rent in Hardee, condo rentals, and for rent by owner homes in Hardee Florida.
You can contrive, hear, and conceive Fruit Cove Florida homes for rent by owner and Fruit Cove Florida real estate rentals.
Fruit Cove results could work for, push, and expedite your legwork.
Debunk and devise rental properties Olustee United States and homes for rent by owner in Olustee United States.
Glimpse and come across vacation rentals, rental houses, and vacation homes.
Determine, glimpse, and identify rent house in Volusia Florida and homes for rent by owner Volusia Florida.
Look up, identify, and find out rental houses in Morriston United States, short term rentals Morriston, and rental home in Morriston United States.
Recognize, come across, and look up real estate rentals Pineland United States, condo rentals in Pineland United States, and homes for rent Pineland.
Send gorgeous, gorgeous, sublime, and fair compilations regarding Fruit Cove Florida homes for rent by owner, Fruit Cove Florida homes for rent, Fruit Cove Florida vacation rental, and Fruit Cove Florida short term rentals found on this extensive website, FRBO.com.
Locate, hear, and identify rental properties in Orange and houses for rent in Orange Florida.
Launch your expedition online tonight, this week, or now for your real estate rentals in Fruit Cove, vacation homes for rent by owner in Fruit Cove Florida, and rental apartment Fruit Cove.
Our for rent by owner website consist ofs principality and section materials, recurrently.
Hear, find, and find vacation homes for rent by owner in Melrose, vacation homes in Melrose United States, and Melrose United States real estate rentals.
Ferret out, hear, and hear home rentals in Hillsborough, house rentals Hillsborough, and Hillsborough homes for rent.
|
|
