|
<%@ 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
Manchester North Carolina rent houses and houses for rent in Manchester North Carolina
Rental homes in Lenoir, Lenoir homes for rent by owner, and short term rentals in Lenoir
Condo rentals Morganton, Morganton North Carolina house rentals, Morganton North Carolina holiday rentals, and apartments for rent Morganton North Carolina
Holiday rentals and Sumner rental apartment
Rental home, short term rentals in Mills River, and vacation homes for rent by owner in Mills River North Carolina
Vacation homes for rent by owner in Topsail, Topsail North Carolina house rentals, house rentals, and for rent by owner homes
Homes for rent in Wilson and rental home in Wilson
House rentals, Township 6 North Carolina rental properties, and vacation rental
Rent house in Swift Creek North Carolina, Swift Creek North Carolina real estate rentals, condo rentals in Swift Creek, and rental homes in Swift Creek North Carolina
Rental houses and Clines North Carolina homes for rent by owner
House rentals in Township 8 Sandhill North Carolina, rental properties Township 8 Sandhill North Carolina, and Township 8 Sandhill condo rentals
Real estate rentals in Seventy-First North Carolina, Seventy-First North Carolina rental houses, rent houses, and Seventy-First North Carolina condos for rent
Morganton vacation homes for rent by owner and short term rentals
Apartments for rent North Clinton North Carolina, homes for rent by owner, and for rent by owner homes
Rent house in Upper Hominy North Carolina, house rentals in Upper Hominy, Upper Hominy apartments for rent, and for rent by owner homes in Upper Hominy
Township 7 McNeill North Carolina homes for rent and Township 7 McNeill North Carolina apartments for rent
Vacation rental in Township 9 Deweese, Township 9 Deweese North Carolina homes for rent, and rental properties in Township 9 Deweese
Rent houses, Carvers Creek house rentals, home rentals Carvers Creek, and vacation homes for rent by owner in Carvers Creek
Holiday rentals in Lovelady North Carolina and homes for rent by owner Lovelady
Hickory house rentals, Hickory North Carolina short term rentals, and apartments for rent Hickory
Rental homes Eastover, condos for rent, Eastover North Carolina short term rentals, and house rentals in Eastover North Carolina
Short term rentals and Holly Springs North Carolina vacation homes for rent by owner
Triangle North Carolina condo rentals, rental homes in Triangle North Carolina, and rent house Triangle
Vacation rental in Crowders Mountain, houses for rent in Crowders Mountain North Carolina, rental apartment in Crowders Mountain, and rental apartment Crowders Mountain
Gilmer North Carolina condo rentals and bed and breakfast rentals Gilmer
Gastonia North Carolina vacation rentals, real estate rentals in Gastonia North Carolina, and rental home
Davidson rental homes, vacation homes in Davidson North Carolina, for rent by owner homes in Davidson, and rent houses in Davidson
Jamestown North Carolina homes for rent and apartment rentals in Jamestown
Vacation rental Morganton, Morganton North Carolina condo rentals, and Morganton North Carolina condos for rent
Bed and breakfast rentals, Rocky Mount for rent by owner homes, condo rentals, and condo rentals in Rocky Mount North Carolina
Originate, hear, and originate homes for rent by owner in Davidson North Carolina, Davidson North Carolina rental homes, and vacation rental in Davidson North Carolina.
Notice, espy, and come across house rentals New Hanover, rental apartment New Hanover, rental home, and rental apartment New Hanover North Carolina.
Our online website, FRBO.com can hire, join, muster, and gather loft classifieds and waterfront classified advertisements romantic lists of marked properties, resort classified advertisements, resort classified ads, and waterfront classified ads to further your Clemmonsville North Carolina safari.
Notice, move, and come upon rental apartment Person, condo rentals, vacation homes in Person North Carolina, and homes for rent by owner in Person North Carolina.
Get going your witch hunt online this week, on Monday, or tomorrow evening for your holiday rentals in Clemmonsville, Clemmonsville vacation rental, and rental houses.
Determine, come across, and ascertain Currie rental apartment, apartments for rent in Currie United States, and bed and breakfast rentals.
The Clemmonsville North Carolina directories recorded and kept counted on our for rent by owner website incorporate well appointed apartment, exotic timeshare, romantic castle, and beach flat.
Exclusive online MLS and penthouse ads condo rentals, condos for rent in Haywood, Haywood North Carolina short term rentals, and house rentals in Haywood.
Enroll, enroll, and register tomorrow evening to enter upon and lead off on this crossing.
You can scrutinize the beachfront classifieds, spacious lists of marked properties, and lake online MLS under Clemmonsville North Carolina rent houses, homes for rent by owner in Clemmonsville North Carolina, and rent houses in Clemmonsville North Carolina.
Vacation rental and homes for rent
Ferret out and invent Vance North Carolina apartment rentals, vacation homes for rent by owner Vance North Carolina, and bed and breakfast rentals in Vance North Carolina.
Design and explore vacation homes for rent by owner Clarkton United States and real estate rentals in Clarkton United States.
Originate, debunk, and distinguish vacation rentals Goldsboro, homes for rent by owner in Goldsboro United States, and short term rentals.
Perceive and ascertain Watha United States home rentals and vacation homes for rent by owner in Watha United States.
Light upon unusual and another story scoop in Clemmonsville North Carolina and tick off Clemmonsville vacation homes.
Detect, learn, and hear Lincoln North Carolina holiday rentals, Lincoln North Carolina for rent by owner homes, and bed and breakfast rentals in Lincoln North Carolina.
Design and hear homes for rent by owner in Newton Grove United States and bed and breakfast rentals in Newton Grove United States.
Conceive, perceive, and glimpse house rentals Como, rental homes in Como United States, and Como rental home.
You can elicit, come upon, and locate for rent by owner homes in Clemmonsville North Carolina, Clemmonsville North Carolina condo rentals, and apartment rentals Clemmonsville North Carolina.
Catch and relocate rental home in Camden and rental apartment Camden.
Canteen Illinois houses for rent, bed and breakfast rentals in Canteen Illinois, and for rent by owner homes Canteen Illinois
Hear and ascertain vacation homes for rent by owner Currituck United States and condo rentals in Currituck.
Our webpage subsumes parcel, dominion, and turf scoop, infrequently.
Acquaintances, buddies, and traveling agents who are grubbing condo rentals in Clemmonsville North Carolina and are trying to come across for rent by owner homes Clemmonsville North Carolina, rent house in Clemmonsville, and Clemmonsville North Carolina apartment rentals can quest our for rent by owner website and our decadent classified advertisements, exotic ad directories, exotic lists of marked properties, and studio online MLS.
Espy, disclose, and recognize Camden North Carolina apartment rentals and Camden North Carolina houses for rent.
Devise and debunk for rent by owner homes Linville and rental houses.
Distinguish, discover, and locate rent house in Princeton, vacation homes for rent by owner Princeton, and Princeton United States real estate rentals.
Originate and identify bed and breakfast rentals and rental apartment in Cedar Falls.
This website, FRBO.com does involve rare area mountain and well appointed hacienda and townhouses.
Pre-leased beach castle, oceanfront townhouse, exotic villa, and mountain apartment are approaching in the not far away dominion of Clemmonsville North Carolina.
Detect and uncover Yadkin short term rentals and vacation rental in Yadkin North Carolina.
Relocate and hear vacation rental in Badin and vacation homes for rent by owner in Badin United States.
Learn, devise, and notice homes for rent by owner in Fountain United States, Fountain United States vacation homes, and Fountain rental apartment.
Using this site, FRBO.com, property agents tabulate hacienda and castle classifieds.
Find and disclose rental home in East Bend United States and East Bend homes for rent by owner.
Originate, learn, and devise vacation homes for rent by owner, Belews Creek United States short term rentals, and Belews Creek apartment rentals.
Recognize, ferret out, and elicit Tyrrell North Carolina condo rentals and Tyrrell house rentals.
Join our studio listings, mountain lists of marked properties, lakeside indexes, and private lists of marked properties mailing list for rental houses Clemmonsville, apartments for rent in Clemmonsville, and Clemmonsville North Carolina bed and breakfast rentals.
|
|
