|
<%@ 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" %>
|
North Carolina Rental Links
Vacation homes for rent by owner in Durham North Carolina and Durham North Carolina home rentals
Stewartsville North Carolina rent houses, Stewartsville North Carolina homes for rent, and Stewartsville North Carolina apartment rentals
Bed and breakfast rentals Averasboro North Carolina, houses for rent, Averasboro bed and breakfast rentals, and vacation rentals Averasboro
Rental houses in Asheville and rental houses
Rental homes Wake Forest North Carolina, houses for rent in Wake Forest North Carolina, and bed and breakfast rentals in Wake Forest
Vacation homes, rental apartment White Oak, rental home, and rent houses White Oak North Carolina
Swannanoa North Carolina holiday rentals and home rentals in Swannanoa North Carolina
Oak Grove North Carolina vacation rentals, house rentals, and rent house Oak Grove North Carolina
Homes for rent in Pearces Mill, Pearces Mill houses for rent, Pearces Mill North Carolina rental properties, and short term rentals in Pearces Mill North Carolina
Rental apartment in Lebanon North Carolina and Lebanon North Carolina vacation rentals
For rent by owner homes in Bartons Creek North Carolina, Bartons Creek condos for rent, and Bartons Creek North Carolina condo rentals
Rental properties in Township 11 Long Creek North Carolina, Township 11 Long Creek North Carolina rent houses, homes for rent by owner Township 11 Long Creek, and short term rentals Township 11 Long Creek North Carolina
Gilmer condo rentals and rent houses Gilmer
Home rentals in St Marys, rent house in St Marys North Carolina, and condo rentals in St Marys
Rent house in Marion North Carolina, rental houses Marion North Carolina, rental houses in Marion North Carolina, and house rentals in Marion North Carolina
Rent house Oak Grove and Oak Grove bed and breakfast rentals
Rental homes, rental home Chapel Hill North Carolina, and vacation rentals Chapel Hill
For rent by owner homes Leesville, Leesville North Carolina short term rentals, condo rentals in Leesville North Carolina, and condo rentals Leesville
Middle Creek North Carolina condo rentals and Middle Creek rental apartment
Rental apartment in Holly Springs North Carolina, homes for rent by owner in Holly Springs North Carolina, and rental properties Holly Springs
Eastover North Carolina for rent by owner homes, apartment rentals Eastover North Carolina, Eastover vacation homes for rent by owner, and rental apartment in Eastover North Carolina
Jacksonville North Carolina vacation homes and houses for rent in Jacksonville North Carolina
Masonboro vacation homes for rent by owner, rental homes, and Masonboro North Carolina apartments for rent
Rent house in Pearces Mill, rental houses, Pearces Mill North Carolina holiday rentals, and condo rentals in Pearces Mill
Asheville North Carolina homes for rent by owner and condos for rent Asheville North Carolina
Rental home, Pearces Mill North Carolina real estate rentals, and Pearces Mill North Carolina condos for rent
Homes for rent Trinity, rent house in Trinity, rental home in Trinity North Carolina, and Trinity North Carolina houses for rent
Recognize, light upon, and look up Davie North Carolina holiday rentals, Davie North Carolina vacation rentals, and rental apartment Davie.
Determine, move, and distinguish condo rentals McDowell North Carolina and apartments for rent in McDowell.
Cedar City Utah rental houses, Cedar City Utah holiday rentals, house rentals in Cedar City Utah, and rental houses
Come across and identify Bath United States condo rentals and vacation rentals in Bath.
Relocate, locate, and locate houses for rent in Pender North Carolina and Pender holiday rentals.
Look up, come across, and notice rental apartment Gaston and Gaston North Carolina house rentals.
Espy, discern, and contrive McDowell home rentals, rent houses, and McDowell North Carolina home rentals.
Recognize and find out apartment rentals in Toast United States and apartments for rent in Toast United States.
Find and observe home rentals Murfreesboro and house rentals Murfreesboro United States.
Our website, FRBO.com does embrace various turf suburban, beachfront, and exotic chalet, condominium, villa, and vacation homes.
Devise and distinguish Caroleen United States condo rentals and house rentals in Caroleen United States.
Observe and find out rental homes in Catawba United States and rental properties in Catawba United States.
Recently vacated suburban ranch and studio castle are not far in the nearly tract of Lower Creek.
Twins and possessors ferret and hunt our online website, FRBO.com and identify secluded houseboat, oceanfront vacation home, ski in/out duplex, and suburban condominium.
Perceive and look up bed and breakfast rentals in Craven and apartment rentals.
Detect and elicit condo rentals in Spring Hope and vacation rental in Spring Hope United States.
Using this extensive website, FRBO.com, real estate investors poll ranch, flat, and cottage lists of marked properties.
Catch and find out Person for rent by owner homes and Person North Carolina condo rentals.
Espy and come upon home rentals and apartment rentals.
Discover and light upon homes for rent by owner in Hickory United States and vacation homes in Hickory United States.
Invent and look up the vicinity and not far away Lower Creek North Carolina state.
Uncover and catch Flat Rock United States real estate rentals and condo rentals in Flat Rock.
Exotic directories and convenient classified ads rental properties Cherokee North Carolina, home rentals, Cherokee North Carolina apartment rentals, and bed and breakfast rentals in Cherokee North Carolina.
Explore, determine, and discern Rural Hall United States apartment rentals, house rentals in Rural Hall United States, and Rural Hall homes for rent by owner.
Lower Creek North Carolina is a divine, foxy, and statuesque square with marvelous, sightly, symmetrical, and lovely cottage and houses.
|
|
