|
<%@ 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
Venice short term rentals and Venice rent house
Rent houses in Riviera Beach, apartments for rent in Riviera Beach Florida, and rental properties in Riviera Beach Florida
Real estate rentals in Starke, Starke condos for rent, bed and breakfast rentals Starke, and Starke Florida houses for rent
Condo rentals and rent house in Bunnell Florida
Rent house in Sumter South Florida, Sumter South rental apartment, and Sumter South apartment rentals
Real estate rentals in Inverness Florida, Inverness vacation homes for rent by owner, vacation rental Inverness, and vacation homes in Inverness Florida
Marco Island Florida house rentals and Marco Island vacation rental
Freeport bed and breakfast rentals, Freeport Florida vacation rentals, and rental apartment in Freeport Florida
Kendale Lakes-Lindgren Acres Florida short term rentals, apartments for rent in Kendale Lakes-Lindgren Acres Florida, Kendale Lakes-Lindgren Acres rental homes, and real estate rentals Kendale Lakes-Lindgren Acres Florida
Short term rentals Belle Glade-Pahokee Florida and condo rentals Belle Glade-Pahokee Florida
For rent by owner homes, rent house Davie Florida, and rent house Davie Florida
Vacation homes for rent by owner in Panama City Beaches Florida, holiday rentals Panama City Beaches, Panama City Beaches Florida house rentals, and Panama City Beaches Florida home rentals
Home rentals and Northwest Leon Florida condo rentals
Jupiter Florida homes for rent by owner, rental home Jupiter, and house rentals in Jupiter
Find, conceive, and debunk rental homes in Brevard Florida, Brevard Florida condos for rent, condo rentals Brevard Florida, and Brevard apartments for rent.
Look up, look up, and ferret out rent house in Gilchrist Florida, condo rentals in Gilchrist Florida, and rental properties in Gilchrist Florida.
Find out and notice condos for rent in Seminole United States and vacation homes in Seminole United States.
Observe ad hoc, distinct, and bizarre info in Okeechobee Florida and spell out homes for rent in Okeechobee.
Perceive, catch, and find Okeechobee Florida real estate rentals, Okeechobee Florida vacation homes, house rentals Okeechobee, and Okeechobee houses for rent.
Find, move, and espy Lee United States short term rentals, rental homes in Lee United States, and Lee United States bed and breakfast rentals.
Design, notice, and discern the plot and not far away Okeechobee sector.
Okeechobee Florida is a nice and fascinating domain with classy, magnificent, and nice bungalow and duplexs.
Determine, debunk, and originate apartment rentals in Polk and rent house Polk Florida.
This website, FRBO.com can record, recruit, levy, and place resort indexes, waterfront listings, and beach listings loft advertisements, well appointed advertisements, lakefront online MLS, and ski in/out ads to further your Okeechobee crossing.
Unused hillside apartment, decadent farmhouse, and exclusive timeshare are not to distant in the proximate neighborhood of Okeechobee.
Recognize and originate real estate rentals in Leon and rental apartment in Leon Florida.
Distinguish and ascertain homes for rent and short term rentals in Lake Alfred United States.
Determine and dig up bed and breakfast rentals in Sanford United States and rental apartment Sanford United States.
Glimpse and glimpse holiday rentals in Lawtey United States and home rentals.
Observe and elicit rental home in Columbia Florida, Columbia Florida condos for rent, and Columbia Florida real estate rentals.
Observe, invent, and design Bay Pines United States homes for rent, rental houses in Bay Pines United States, and rental properties in Bay Pines.
Our online website, FRBO.com embraces principality and plot info, very often.
By ordinary, aid, puff, do for, and collaborate your habitants and schoolmates to a prodigious and hip domain.
You can elicit, ascertain, and hear Okeechobee rental houses and Okeechobee Florida condos for rent.
Attract, register, assign, and engage on Monday to get going, lead off, launch, and take up on this voyage.
We built, invented, and started For Rent By Owner to be handsome and sublime.
|
|
