|
<%@ 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
Bed and breakfast rentals Township 6 Shelby and Township 6 Shelby rent house
Cherryville North Carolina bed and breakfast rentals, houses for rent Cherryville North Carolina, and Cherryville apartment rentals
Homes for rent in Jamestown North Carolina, Jamestown North Carolina rent house, vacation rental in Jamestown North Carolina, and Jamestown North Carolina homes for rent
Rental apartment in Locke and bed and breakfast rentals
Vacation homes for rent by owner in Roxboro North Carolina, rent houses in Roxboro North Carolina, and rental apartment
Statesville rental apartment, Statesville rental properties, homes for rent by owner in Statesville North Carolina, and vacation rentals in Statesville North Carolina
Real estate rentals in Leicester North Carolina and homes for rent by owner in Leicester North Carolina
Homes for rent in Asheville North Carolina, vacation homes for rent by owner in Asheville North Carolina, and vacation rentals in Asheville North Carolina
For rent by owner homes in Hudson North Carolina, houses for rent Hudson North Carolina, for rent by owner homes in Hudson, and Hudson holiday rentals
Apartments for rent in Township 11 Central Cabarrus North Carolina and Township 11 Central Cabarrus North Carolina rental properties
The Litaker North Carolina lists of marked properties tabbed and inscribed on our online website, FRBO.com enclose penthouse farmhouse, well appointed vacation home, and private farmhouse.
Find out and discover Gates North Carolina rental houses and house rentals.
Unused ski in/out farmhouse and ski in/out villa are next in the near-at-hand locality of Litaker North Carolina.
Discover distinctive and some results in Litaker North Carolina and button down condo rentals Litaker.
You can cast about the private directories, beach ads, romantic ads, and resort indexes under Litaker North Carolina rental apartment, real estate rentals in Litaker North Carolina, and vacation rental Litaker.
Ascertain, conceive, and ferret out rent house Icard, rental home Icard United States, and short term rentals in Icard United States.
Beachfront ads and romantic classifieds apartments for rent, rental houses Swain North Carolina, rent houses, and rental properties Swain North Carolina.
At times, open doors, benefit, aid, and facilitate your natives and road warriors to a hefty, magnetic, burly, and enticing precinct.
Ascertain, come across, and discern condos for rent in Halifax North Carolina, Halifax rent houses, apartments for rent in Halifax, and bed and breakfast rentals in Halifax North Carolina.
Design and light upon Clemmons United States rental properties and rental home in Clemmons.
Teachers and commuters who are wishing to ascertain, catch, and espy or simply design information can use our website, FRBO.com.
Litaker town home owners and property agents list Litaker houses for rent, condos for rent, rental properties in Litaker, and short term rentals Litaker North Carolina.
Perceive and find out rental home and rental home in Mount Gilead.
Litaker North Carolina principality employs many rental property owners, real estate agents, and third party agents.
Catch and design rental properties in Franklin United States and vacation rental Franklin.
The Litaker North Carolina resort advertisements and beachfront lists of marked properties for these vicinity can be mapped.
Distinguish, ascertain, and originate real estate rentals in Pasquotank North Carolina, apartment rentals, and Pasquotank North Carolina rental homes.
Debunk and design Durham bed and breakfast rentals, vacation homes in Durham North Carolina, Durham vacation homes for rent by owner, and rental apartment Durham.
Embark on your chase online day after tomorrow or next weekend for your condo rentals in Litaker and Litaker condos for rent.
Uncover and dig up Roper United States homes for rent and short term rentals Roper United States.
Send magnificent and graceful score regarding house rentals Litaker North Carolina, Litaker rental apartment, and rental home found on our website, FRBO.com.
You can debunk, recognize, and catch rent houses, vacation homes for rent by owner Litaker, and rent house in Litaker.
Transmigrants and citizens inspect, go through, and forage FRBO.Com, For Rent By Owner, and uncover mountain hacienda and waterfront bungalow.
|
|
