|
<%@ 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
Apartments for rent in Fellsmere and rental houses in Fellsmere
Rental homes Indialantic-Melbourne Beach, vacation rental Indialantic-Melbourne Beach, and home rentals
Princeton-Goulds Florida rental apartment, rent houses, apartments for rent in Princeton-Goulds Florida, and Princeton-Goulds homes for rent
Rent house in Thonotosassa and Thonotosassa Florida apartment rentals
Fort White condo rentals, vacation rentals Fort White Florida, and Fort White Florida apartments for rent
Rental homes in Cross City North, Cross City North Florida for rent by owner homes, rent houses in Cross City North, and bed and breakfast rentals
House rentals in Lake Worth Florida and rental houses
Rental apartment Naples Florida, vacation rental, and Naples Florida rental houses
Homes for rent in Lake Placid Florida, Lake Placid Florida rental houses, rental houses Lake Placid Florida, and house rentals in Lake Placid
Homes for rent and rental home in Lower Keys
Quincy Florida apartment rentals, vacation homes for rent by owner in Quincy Florida, and Quincy vacation rental
Havana Florida rental homes, condos for rent Havana Florida, rental home Havana Florida, and apartments for rent in Havana Florida
Houses for rent in Interior County Florida and rent houses in Interior County Florida
Miami rental houses, rental home in Miami Florida, and apartment rentals Miami Florida
Wauchula Florida rental home, houses for rent, Wauchula Florida holiday rentals, and apartment rentals in Wauchula Florida
Bed and breakfast rentals Green Cove Springs Florida and rent houses Green Cove Springs
Fort McCoy-Anthony Florida vacation rental, Fort McCoy-Anthony Florida homes for rent, and Fort McCoy-Anthony rental properties
Rent houses in Plantation Florida, vacation rental, rental houses in Plantation Florida, and Plantation Florida apartments for rent
Riviera Beach houses for rent and vacation homes for rent by owner Riviera Beach Florida
For rent by owner homes Margate, holiday rentals in Margate Florida, and real estate rentals Margate
East Leon Florida apartment rentals, condo rentals in East Leon Florida, house rentals in East Leon Florida, and holiday rentals in East Leon
Eglin short term rentals and condo rentals in Eglin Florida
Rental properties Southwest Orange Florida, rental properties in Southwest Orange, and Southwest Orange Florida condo rentals
Rental home Grove City-Rotonda Florida, Grove City-Rotonda Florida rent houses, condo rentals in Grove City-Rotonda, and Grove City-Rotonda Florida rental home
Originate and discover homes for rent by owner and condo rentals.
Find and espy houses for rent in Highlands Florida and Highlands Florida rental homes.
Lead off your witch hunt online on Wednesday, tomorrow morning, in the next few days, or now for your vacation rental and East Marion Florida vacation homes for rent by owner.
Discern and invent bed and breakfast rentals in Franklin Florida, vacation homes Franklin, and rental houses in Franklin Florida.
Observe and light upon Pinellas rent houses, Pinellas short term rentals, and house rentals in Pinellas.
Hire, hitch, and serve in the morning to jump into and originate on this wandering.
Recurrently, plug, aid, relieve, and push your navigators, traveling agents, and seafarers to a agreeable and gorgeous field.
Distinguish, disclose, and relocate Doctors Inlet homes for rent by owner, homes for rent in Doctors Inlet, and rental houses Doctors Inlet.
See exclusive lists of marked properties and beachfront lists of marked properties that rental owners and town home owners post on this site, FRBO.com.
Observe and disclose rent house Wakulla Florida, vacation homes Wakulla Florida, rental homes in Wakulla, and rental houses in Wakulla Florida.
We performed, designed, and conceived our site, FRBO.com to be cute, wonderful, and well-formed.
East Marion Florida picture could assist, ride shotgun, and support your pursuit.
Observe and relocate rental homes in Pinellas Florida and condo rentals Pinellas Florida.
Using this website, FRBO.com, land owners write down timeshare, house, and chalet listed properties.
Locate, learn, and locate homes for rent Hampton United States, Hampton real estate rentals, and condo rentals in Hampton United States.
Move, relocate, and find out home rentals in Highlands Florida and rental homes.
Notice and catch houses for rent Mexico Beach and Mexico Beach United States rental houses.
Identify and ferret out condos for rent in Eastpoint United States and short term rentals in Eastpoint.
Come upon and locate rental houses Saint James City and homes for rent.
Determine, contrive, and ferret out bed and breakfast rentals Gulf Florida and apartments for rent in Gulf Florida.
Send enticing and superb reports regarding East Marion condos for rent and East Marion Florida bed and breakfast rentals found on this extensive website, FRBO.com.
Recognize and debunk rental properties in Pasco Florida, holiday rentals Pasco Florida, and apartment rentals in Pasco Florida.
Look up, perceive, and invent condos for rent in Hardee Florida, Hardee Florida home rentals, rental apartment in Hardee Florida, and condo rentals.
Glimpse, determine, and dig up houses for rent in Copeland United States, Copeland holiday rentals, and Copeland United States houses for rent.
Learn, locate, and come across home rentals in Manatee Florida, Manatee rent house, and vacation homes for rent by owner in Manatee.
Locate, elicit, and elicit house rentals, house rentals in Telogia, and house rentals in Telogia.
Vacated resort apartment, suburban houseboat, penthouse timeshare, and spacious duplex are adjoining in the not to distant square of East Marion Florida.
Find, identify, and perceive apartment rentals in Fort Pierce United States, Fort Pierce United States vacation rental, and rental home in Fort Pierce United States.
Distinguish, identify, and light upon rental properties Jasper United States, real estate rentals Jasper United States, and Jasper United States rental houses.
Elicit specific, atypical, extraordinary, and specialized experiments in East Marion Florida and note real estate rentals East Marion Florida.
|
|
