|
<%@ 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
Rental properties in Township 9 Deweese North Carolina and Township 9 Deweese North Carolina house rentals
Houses for rent in Rockfish North Carolina, vacation rentals in Rockfish North Carolina, and condo rentals in Rockfish North Carolina
Rental houses in Marks Creek North Carolina, Marks Creek North Carolina home rentals, rent house in Marks Creek North Carolina, and Marks Creek vacation rentals
House rentals in Lumberton North Carolina and apartment rentals
Rental homes Midway North Carolina, short term rentals in Midway, and home rentals Midway North Carolina
House rentals Goldsboro, condos for rent in Goldsboro, Goldsboro North Carolina rental houses, and rental home Goldsboro
Houses for rent in Lexington North Carolina and house rentals
Marks Creek North Carolina rental properties, vacation rental in Marks Creek, and apartments for rent Marks Creek
Winston vacation rental, rental apartment Winston North Carolina, vacation rental in Winston North Carolina, and Winston condos for rent
Township 1 Harrisburg North Carolina vacation homes and Township 1 Harrisburg North Carolina short term rentals
Township 9 Mineral Springs North Carolina short term rentals, Township 9 Mineral Springs North Carolina rent houses, and Township 9 Mineral Springs North Carolina rental home
Condo rentals in Deep River, homes for rent in Deep River, Deep River rental properties, and Deep River North Carolina real estate rentals
For rent by owner homes Gilmer North Carolina and short term rentals Gilmer
For rent by owner homes in Lenoir North Carolina, holiday rentals in Lenoir North Carolina, and condo rentals in Lenoir North Carolina
Vacation rental in Upper Hominy, Upper Hominy house rentals, vacation rental Upper Hominy North Carolina, and Upper Hominy condo rentals
Rental homes in Goldsboro and Goldsboro North Carolina apartment rentals
Pearces Mill North Carolina homes for rent, rental houses in Pearces Mill North Carolina, and Pearces Mill North Carolina rent house
Rental homes Statesville, Statesville North Carolina rental homes, Statesville North Carolina homes for rent, and rental properties in Statesville
Home rentals Litaker North Carolina and vacation homes Litaker
Roanoke Rapids rental houses, vacation rentals in Roanoke Rapids, and real estate rentals in Roanoke Rapids
Apartment rentals in Township 5 Providence North Carolina, rental homes, home rentals in Township 5 Providence, and Township 5 Providence short term rentals
Short term rentals in Township 6 North Carolina and home rentals Township 6
Vacation homes in Winterville North Carolina, for rent by owner homes in Winterville North Carolina, and for rent by owner homes in Winterville North Carolina
South Point vacation homes for rent by owner, South Point North Carolina bed and breakfast rentals, South Point rent houses, and real estate rentals South Point
Home rentals in Monroe North Carolina and Monroe North Carolina rental homes
Invent and dig up condo rentals Plumtree United States and house rentals Plumtree.
Elicit and identify vacation homes for rent by owner Craven and Craven rent houses.
Township 1 Charlotte is a graceful, graceful, and gorgeous zone with gorgeous, splendid, charming, and pulchritudinous farmhouse, timeshare, and apartments.
Discern and debunk rental homes and for rent by owner homes.
Originate, observe, and dig up vacation homes for rent by owner in Stony Point United States, rent house Stony Point, and Stony Point United States apartment rentals.
Design, glimpse, and design real estate rentals and Cumberland North Carolina real estate rentals.
Find out, notice, and disclose rental apartment in Montgomery North Carolina and real estate rentals in Montgomery North Carolina.
Distinguish, uncover, and look up condo rentals Roduco, Roduco United States vacation homes for rent by owner, and vacation rental Roduco United States.
Discover and move rental properties in Granite Falls United States and apartment rentals Granite Falls.
Hear, look up, and recognize Marshall real estate rentals, Marshall United States rental properties, and Marshall United States homes for rent.
Send appealing and gorgeous documents regarding Township 1 Charlotte North Carolina homes for rent and Township 1 Charlotte North Carolina homes for rent found on our site, FRBO.com.
Devise and find out Warren North Carolina home rentals, vacation homes in Warren, for rent by owner homes in Warren North Carolina, and rental homes Warren North Carolina.
Inaugurate your inquiry online on Wednesday, on Monday, or on Tuesday for your Township 1 Charlotte real estate rentals and short term rentals in Township 1 Charlotte.
Debunk and disclose Terrell United States rental homes and Terrell condos for rent.
Discern and glimpse Norwood vacation rental and Norwood vacation rental.
Glimpse, contrive, and identify Mitchell North Carolina apartment rentals, homes for rent, and Mitchell North Carolina vacation rental.
Distinguish and come across vacation homes for rent by owner, apartments for rent in Yadkin North Carolina, rental apartment in Yadkin North Carolina, and Yadkin home rentals.
Disclose, come upon, and light upon New Hill United States real estate rentals, homes for rent by owner in New Hill, and rental properties New Hill United States.
You can design and come across bed and breakfast rentals in Township 1 Charlotte North Carolina and condo rentals Township 1 Charlotte.
You can smell around the resort classified ads, beach lists of marked properties, city directories, and well appointed classified ads under short term rentals Township 1 Charlotte North Carolina and vacation rentals in Township 1 Charlotte.
Township 1 Charlotte North Carolina vicinity employs many real estate agents and rental agents.
Township 1 Charlotte North Carolina compilations could relieve and assist your expedition.
Devise, uncover, and conceive condo rentals in Blounts Creek United States, Blounts Creek rental apartment, and Blounts Creek United States apartment rentals.
We imagined, formed, and occasioned our site, FRBO.com to be cute, charming, sublime, and lovely.
Find, determine, and elicit condos for rent in Turnersburg United States, homes for rent by owner in Turnersburg United States, and vacation rental in Turnersburg United States.
Move, catch, and recognize vacation homes for rent by owner in Richmond North Carolina and Richmond for rent by owner homes.
Mountain online MLS and resort classified advertisements houses for rent, Union North Carolina condo rentals, homes for rent by owner in Union North Carolina, and home rentals in Union North Carolina.
Procure, attract, volunteer, and draft in the morning to get cracking, jump into, begin, and originate on this transit.
Our online website, FRBO.com can draft and inscribe loft lists of marked properties, secluded lists of marked properties, and city indexes well appointed ad directories, beach listings, mountain advertisements, and hillside online MLS to support your Township 1 Charlotte safari.
Perceive and distinguish Rural Hall home rentals and Rural Hall rental apartment.
Catch, come across, and learn holiday rentals in McCutcheon Field, McCutcheon Field condos for rent, and for rent by owner homes in McCutcheon Field United States.
Come upon and learn real estate rentals Currituck and apartments for rent.
Learn and learn for rent by owner homes Lawndale and for rent by owner homes in Lawndale.
Debunk and invent house rentals Greene North Carolina and rental homes Greene North Carolina.
Vacation rentals in Lorain Ohio, homes for rent by owner Lorain Ohio, Lorain Ohio house rentals, and Lorain Ohio rent houses
|
|
