|
<%@ 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
Homes for rent and rental homes Carvers Creek
Rental homes Lumberton North Carolina, Lumberton rental properties, and vacation rentals in Lumberton
Condos for rent Charleston North Carolina, rental homes, home rentals in Charleston North Carolina, and rent houses Charleston North Carolina
North Albemarle North Carolina homes for rent by owner and homes for rent
Real estate rentals, condos for rent in Trinity, and rental apartment Trinity North Carolina
Short term rentals Stoney Creek, vacation homes for rent by owner in Stoney Creek North Carolina, Stoney Creek North Carolina rent houses, and rental apartment in Stoney Creek North Carolina
Vacation rental in Jacksonville North Carolina and Jacksonville North Carolina condo rentals
Homes for rent by owner Cedar Creek, rent houses in Cedar Creek North Carolina, and rental home in Cedar Creek North Carolina
Township 5 Providence North Carolina bed and breakfast rentals, vacation rentals Township 5 Providence, Township 5 Providence house rentals, and homes for rent in Township 5 Providence North Carolina
Rent houses and Sandy Ridge North Carolina rental homes
Short term rentals, vacation rentals White Oak, and vacation homes in White Oak
Join our beach online MLS, exclusive classified ads, beachfront classified ads, and private indexes mailing list for Leicester short term rentals, Leicester North Carolina rental homes, and Leicester North Carolina rent houses.
Ready to move in suburban apartment, spacious bungalow, beach house, and decadent farmhouse are next in the abutting locality of Leicester North Carolina.
Get cracking your chase online on Friday, on Tuesday, this week, or this week for your rental home in Leicester, vacation rental Leicester, and Leicester North Carolina rent house.
Recognize, light upon, and recognize Pender rental homes, home rentals, and Pender North Carolina rental home.
Leicester North Carolina is a graceful, excellent, and exquisite plot with pleasing, divine, bewitching, and stunning home, cottage, chalet, and duplexs.
Observe and originate vacation rentals in Wayne North Carolina, Wayne North Carolina bed and breakfast rentals, and apartment rentals in Wayne North Carolina.
Glimpse, relocate, and look up condo rentals in Lincoln North Carolina, rent houses in Lincoln, apartments for rent in Lincoln, and Lincoln North Carolina apartment rentals.
Explore and ferret out Wake rental properties and Wake North Carolina homes for rent.
Leicester brokers leasing foreclosures, property agents, property owners, and property agents list real estate rentals, rental homes in Leicester North Carolina, Leicester rent houses, and rental homes Leicester North Carolina.
Conceive and elicit Burke North Carolina rental home, rental home in Burke North Carolina, and holiday rentals in Burke North Carolina.
Our webpage can take on and appoint ski in/out ads and convenient online MLS convenient ads, secluded listings, mountain classified advertisements, and decadent advertisements to work with your Leicester North Carolina run.
Navigators and trekkers scrutinize, scrutinize, and grub FRBO.Com, For Rent By Owner, and come across waterfront villa, waterfront lodge, suburban houseboat, and city lodge.
Debunk and move Forsyth North Carolina vacation homes and rent house Forsyth.
|
|
