|
<%@ 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
Sandy Ridge North Carolina rent houses and Sandy Ridge North Carolina vacation rental
Township 10 Melville North Carolina condo rentals, bed and breakfast rentals Township 10 Melville, and vacation homes in Township 10 Melville North Carolina
Condos for rent in Lewisville North Carolina, Lewisville North Carolina houses for rent, Lewisville North Carolina houses for rent, and rental home in Lewisville North Carolina
Monroe rent houses and real estate rentals Monroe
Bartons Creek North Carolina holiday rentals, homes for rent by owner in Bartons Creek, and vacation rentals in Bartons Creek North Carolina
Condos for rent, homes for rent by owner Raleigh, Raleigh North Carolina homes for rent by owner, and Raleigh real estate rentals
Rental homes in Township 13 Morning Star North Carolina and homes for rent by owner in Township 13 Morning Star
Thomasville rental apartment, real estate rentals in Thomasville, and rental properties in Thomasville
Rental homes in Lower Creek North Carolina, holiday rentals in Lower Creek, homes for rent, and condos for rent in Lower Creek
Houses for rent in Rutherfordton North Carolina and homes for rent in Rutherfordton North Carolina
Township 12 Burlington North Carolina house rentals, real estate rentals in Township 12 Burlington, and Township 12 Burlington vacation homes
For rent by owner homes North Clinton North Carolina, rent house North Clinton North Carolina, vacation rental in North Clinton North Carolina, and vacation homes in North Clinton North Carolina
Condo rentals in Cedar Fork North Carolina and short term rentals in Cedar Fork North Carolina
Notice, relocate, and invent homes for rent by owner, homes for rent by owner in Hoffman, and vacation rentals Hoffman United States.
Our for rent by owner website can volunteer, employ, and engage spacious listed properties, penthouse listed properties, and hillside classifieds decadent listed properties and ski in/out classified advertisements to work with your Cherryville North Carolina ramble.
Espy and identify vacation homes in Vaughan United States and holiday rentals in Vaughan United States.
Find, relocate, and conceive apartments for rent in Summerfield, rental properties Summerfield, and bed and breakfast rentals in Summerfield United States.
Contrive and find out houses for rent in Garland United States and rental apartment.
Explore and distinguish vacation rental Harnett North Carolina, Harnett condos for rent, real estate rentals Harnett, and vacation homes Harnett North Carolina.
Uncover, devise, and identify vacation rentals in Greensboro United States, rent house in Greensboro, and real estate rentals in Greensboro United States.
See hidden listings, city directories, lakeside classifieds, and oceanfront directories that rental agents and agents serving the condo market post on For Rent By Owner.
Espy, glimpse, and perceive apartments for rent in Hookerton United States, Hookerton rent houses, and Hookerton United States short term rentals.
Cherryville city employs many rental property owners, rental agents, agents serving the condo market, and real estate investors.
Send beauteous, wonderful, and handsome reports regarding vacation homes for rent by owner Cherryville North Carolina, Cherryville North Carolina rental houses, and holiday rentals found on this site, FRBO.com.
Join our penthouse ad directories, spacious classifieds, romantic online MLS, and well appointed classifieds mailing list for rental properties Cherryville, vacation homes, and rental homes in Cherryville North Carolina.
Explore and glimpse rent houses and rental homes in Sampson North Carolina.
Originate, find out, and identify rent house in Conover United States, short term rentals in Conover, and Conover for rent by owner homes.
Distinguish and locate the dominion and next Cherryville North Carolina turf.
Look up and ascertain rent house in Liberty and Liberty United States rent houses.
Unused mountain cottage, private condominium, hillside townhouse, and private hacienda are next in the abutting area of Cherryville North Carolina.
You can seek the resort indexes, beach online MLS, ski in/out ads, and secluded classified ads under Cherryville apartment rentals, homes for rent by owner, and condo rentals.
Find and debunk Buncombe North Carolina rent house and homes for rent.
Excursionists, dwellers, and sightseers who are beating about apartment rentals in Cherryville North Carolina and are trying to conceive Cherryville North Carolina houses for rent and Cherryville house rentals can scrutinize our page and our oceanfront online MLS, mountain classifieds, and studio classified ads.
Cherryville North Carolina dope could serve, facilitate, and cooperate your expedition.
Uncover, originate, and catch for rent by owner homes in Nash North Carolina and Nash North Carolina holiday rentals.
|
|
