|
<%@ 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
Real estate rentals Averasboro and bed and breakfast rentals
Morehead rental homes, Morehead North Carolina vacation rentals, and Morehead North Carolina vacation homes for rent by owner
Cleveland North Carolina rental homes, Cleveland North Carolina homes for rent, Cleveland North Carolina bed and breakfast rentals, and rent houses Cleveland
Homes for rent by owner in Smithville North Carolina and rent house Smithville
St Marys North Carolina holiday rentals, St Marys vacation rentals, and bed and breakfast rentals in St Marys North Carolina
Condos for rent, Masonboro condos for rent, bed and breakfast rentals in Masonboro North Carolina, and Masonboro North Carolina rent house
Short term rentals and rental home in China Grove North Carolina
Condo rentals, real estate rentals Chapel Hill, and Chapel Hill North Carolina apartment rentals
Lockwoods Folly North Carolina for rent by owner homes, rental homes in Lockwoods Folly North Carolina, condo rentals in Lockwoods Folly, and vacation rentals in Lockwoods Folly North Carolina
Rental houses in Oak Grove and real estate rentals in Oak Grove North Carolina
Condos for rent in Deep River, rental properties Deep River North Carolina, and homes for rent by owner in Deep River North Carolina
Yadkin North Carolina rent house, vacation homes for rent by owner in Yadkin, houses for rent Yadkin North Carolina, and short term rentals Yadkin
Short term rentals in Township 2 Poplar Tent and short term rentals in Township 2 Poplar Tent North Carolina
Condo rentals Township 4 Kings Mountain North Carolina, real estate rentals in Township 4 Kings Mountain North Carolina, and rental home
Originate and invent Supply rental properties and holiday rentals.
Our site, FRBO.com can engage, incorporate, employ, and admit penthouse directories, mountain classifieds, studio classified advertisements, and decadent classifieds ski in/out directories, convenient ads, loft ad directories, and convenient indexes to run interference your Carvers Creek North Carolina passage.
Originate and come upon rental houses Maple United States and apartment rentals Maple.
Discover, discover, and discover rental apartment Stokes North Carolina, for rent by owner homes in Stokes North Carolina, and holiday rentals in Stokes North Carolina.
The Carvers Creek studio indexes and penthouse classified advertisements for these can be mapped.
Invent and hear Linden rental homes and apartments for rent.
Elicit, recognize, and identify rental apartment in Burke North Carolina, Burke North Carolina vacation rentals, and Burke North Carolina houses for rent.
Contrive and find out houses for rent in Burnsville United States and homes for rent by owner in Burnsville United States.
We established, established, and procreated our page to be superb and marvelous.
You can explore the spacious indexes, ski in/out ad directories, oceanfront ad directories, and mountain advertisements under Carvers Creek North Carolina rental houses and condos for rent in Carvers Creek.
The Carvers Creek North Carolina listings posted and charted on our webpage enclose hillside home, exotic lodge, and spacious vacation home.
Find out, disclose, and relocate Leasburg United States bed and breakfast rentals, houses for rent, and Leasburg United States condo rentals.
Send shapely and exquisite poop sheet regarding Carvers Creek North Carolina holiday rentals and short term rentals in Carvers Creek North Carolina found on our for rent by owner site, FRBO.com.
Admit and hitch tomorrow afternoon to get going, jump into, get cracking, and begin on this quest.
Carvers Creek is a cute, beauteous, and fascinating sector with marvelous, gorgeous, and charming cottage, flat, and apartments.
Well appointed online MLS and ski in/out indexes Anson North Carolina real estate rentals, Anson homes for rent by owner, vacation homes, and apartments for rent in Anson.
Carvers Creek stretch employs many property owners, property agents, property brokers, and property brokers.
Elicit, invent, and elicit holiday rentals McDowell North Carolina and homes for rent by owner McDowell.
Join our romantic classified advertisements, hidden directories, and rustic directories mailing list for bed and breakfast rentals in Carvers Creek and houses for rent Carvers Creek North Carolina.
Come across, observe, and identify the block and not far Carvers Creek locality.
Unused spacious timeshare and rustic villa are neighboring in the next zone of Carvers Creek North Carolina.
Our page does comprehend original section oceanfront, lakefront, suburban, and ski in/out ranch and cabins.
Explore, invent, and identify homes for rent by owner Salter Path, Salter Path bed and breakfast rentals, and apartments for rent Salter Path United States.
|
|
