|
<%@ 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
Bed and breakfast rentals Umatilla and rental homes
Niceville-Valparaiso rental homes, Niceville-Valparaiso Florida rental houses, and Niceville-Valparaiso rental home
Miami Beach Florida rent houses, rent houses, condos for rent in Miami Beach Florida, and bed and breakfast rentals in Miami Beach Florida
Condo rentals Lake Worth Florida and Lake Worth Florida apartments for rent
Homes for rent by owner North Westside, short term rentals, and condos for rent
Homes for rent by owner Fort Walton Beach, vacation rentals Fort Walton Beach, Fort Walton Beach Florida bed and breakfast rentals, and Fort Walton Beach Florida houses for rent
Vacation rental West Palm Beach Florida and rental houses
Madison Florida house rentals, holiday rentals in Madison Florida, and vacation homes in Madison Florida
Rental homes Lehigh Acres, rent houses, rental houses Lehigh Acres, and vacation rentals in Lehigh Acres Florida
Crystal River Florida apartments for rent and Crystal River Florida apartment rentals
Rent houses in La Belle Florida, La Belle homes for rent by owner, and rental apartment La Belle Florida
Macclenny condos for rent, rental homes Macclenny Florida, bed and breakfast rentals in Macclenny Florida, and rent house in Macclenny
Rental properties Oviedo Florida and vacation homes for rent by owner Oviedo Florida
Rental home in Cross City North Florida, rental apartment, and real estate rentals Cross City North Florida
Homes for rent in Macclenny Florida, bed and breakfast rentals in Macclenny Florida, Macclenny Florida real estate rentals, and Macclenny Florida house rentals
Sebring rental houses and Sebring Florida rental homes
Citrus Park-Fern Lake rental apartment, Citrus Park-Fern Lake Florida apartments for rent, and bed and breakfast rentals in Citrus Park-Fern Lake
We planned, formulated, and coined this site, For Rent By Owner (FRBO.com) to be sightly, statuesque, superb, and magnificent.
Niceville-Valparaiso is a admirable, resplendent, and splendid square with wonderful, alluring, and shapely villa, townhouse, townhouse, and timeshares.
This site, FRBO.com accommodates zone and kingdom abstracts, now and again.
Waterfront ad directories and well appointed listed properties apartments for rent Union Florida, house rentals in Union Florida, Union Florida rent house, and condos for rent Union Florida.
Hear, glimpse, and relocate condo rentals in Lake Geneva, rental homes in Lake Geneva United States, and homes for rent by owner in Lake Geneva United States.
Relocate and contrive rent house, homes for rent Charlotte, and Charlotte Florida apartments for rent.
Join our ski in/out indexes and private listed properties mailing list for Niceville-Valparaiso house rentals and rental houses Niceville-Valparaiso Florida.
Look up and dig up rent houses in Wakulla and Wakulla Florida bed and breakfast rentals.
Disclose and find out Lake Florida rent houses, for rent by owner homes Lake, holiday rentals in Lake Florida, and Lake Florida rent house.
Our for rent by owner website does embody novel tract convenient, beachfront, and waterfront lodge and lodges.
Learn and identify Alturas United States vacation rentals and Alturas United States rental houses.
Move and ferret out Defuniak Springs condo rentals and apartment rentals Defuniak Springs United States.
Perceive, espy, and devise home rentals, homes for rent by owner, rent house Jefferson, and Jefferson rental houses.
Niceville-Valparaiso section employs many real estate agents, third party agents, property brokers, and landlords.
Ofttimes, serve and aid your educators and possessors to a mesmeric and alluring state.
You can smell around the city classified ads, beach online MLS, and secluded directories under vacation rental in Niceville-Valparaiso Florida and vacation rental Niceville-Valparaiso.
Using our website, FRBO.com, property agents manifest townhouse, houseboat, and castle classifieds.
Explore and design house rentals Lynn Haven and short term rentals in Lynn Haven United States.
Niceville-Valparaiso Florida proof could do for, help, and help your fishing expedition.
Come across and notice home rentals in Jackson Florida, Jackson Florida rental properties, and Jackson Florida rent house.
Explore and invent Killarney United States rent houses and holiday rentals Killarney.
Move and notice Holder United States vacation homes for rent by owner and bed and breakfast rentals.
Observe and identify vacation homes and Nassau Florida for rent by owner homes.
Niceville-Valparaiso property managers, third party agents, property owners, and real estate investors list vacation homes in Niceville-Valparaiso Florida, Niceville-Valparaiso Florida homes for rent, and Niceville-Valparaiso rental homes.
Discover, invent, and look up vacation homes Gadsden, home rentals in Gadsden Florida, and rent house in Gadsden.
Find and discover Mango houses for rent and Mango United States rental home.
Send pretty and cute details regarding Niceville-Valparaiso condo rentals, Niceville-Valparaiso Florida rent house, condo rentals in Niceville-Valparaiso, and for rent by owner homes in Niceville-Valparaiso found on this site, FRBO.com.
Come across, recognize, and ascertain apartments for rent and rent houses in Collier Florida.
Perceive and learn Lafayette Florida rent house, Lafayette Florida rental houses, condos for rent in Lafayette Florida, and Lafayette Florida rental home.
Distinguish, find out, and contrive rent house in Lorida, rental apartment, and for rent by owner homes in Lorida United States.
|
|
