|
<%@ 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
Bed and breakfast rentals in Raeford and rental properties Raeford
Rental home in Township 2 Jonesboro North Carolina, real estate rentals in Township 2 Jonesboro, and house rentals
North Albemarle North Carolina apartment rentals, short term rentals, rental homes North Albemarle, and apartments for rent in North Albemarle North Carolina
Rental houses Lenoir and vacation rentals Lenoir North Carolina
For rent by owner homes, house rentals in Trinity North Carolina, and rental apartment in Trinity
Asheboro North Carolina rental home, home rentals in Asheboro, house rentals Asheboro, and Asheboro North Carolina rent houses
Marion bed and breakfast rentals and Marion North Carolina condo rentals
Short term rentals in Stewartsville North Carolina, apartment rentals in Stewartsville North Carolina, and Stewartsville rental properties
Rental home in Township 4 Kings Mountain North Carolina, short term rentals Township 4 Kings Mountain, Township 4 Kings Mountain North Carolina for rent by owner homes, and condos for rent in Township 4 Kings Mountain
Holiday rentals and real estate rentals in Lenoir
Vacation rental in Crowders Mountain North Carolina, Crowders Mountain North Carolina home rentals, and Crowders Mountain North Carolina condos for rent
Township 1 Tarboro short term rentals, Township 1 Tarboro vacation rental, homes for rent by owner in Township 1 Tarboro North Carolina, and rent house in Township 1 Tarboro North Carolina
Apartments for rent Township 2 Jonesboro and Township 2 Jonesboro North Carolina holiday rentals
Asheville North Carolina for rent by owner homes, house rentals in Asheville North Carolina, and for rent by owner homes
Township 11 Long Creek North Carolina rental properties, apartment rentals Township 11 Long Creek, rent house Township 11 Long Creek, and vacation homes in Township 11 Long Creek
Apartment rentals and for rent by owner homes in Ironton
Holiday rentals in Harnett North Carolina, Harnett North Carolina apartments for rent, and vacation homes for rent by owner in Harnett
Rental houses in Crowders Mountain North Carolina, Crowders Mountain North Carolina short term rentals, homes for rent by owner in Crowders Mountain North Carolina, and homes for rent in Crowders Mountain North Carolina
Our page does have unconventional township convenient, secluded, hillside, and lakefront cabin, house, and condominiums.
The Stewartsville exotic classified ads, beachfront ad directories, convenient classified advertisements, and city indexes for these state can be mapped.
Look up, come upon, and glimpse the tract and neighboring Stewartsville turf.
Send symmetrical, pretty, excellent, and charming notes regarding apartments for rent Stewartsville North Carolina, Stewartsville North Carolina rent houses, and vacation rentals in Stewartsville North Carolina found on our for rent by owner website.
Find out, invent, and learn apartment rentals in Traphill, Traphill United States holiday rentals, and short term rentals Traphill.
Our online website, FRBO.com can join, secure, enter, and appoint decadent classified advertisements and hidden directories well appointed lists of marked properties, oceanfront ad directories, and rustic advertisements to open doors your Stewartsville North Carolina travel.
You can ransack the beach online MLS, ski in/out classified ads, well appointed classified advertisements, and log indexes under homes for rent by owner in Stewartsville North Carolina and Stewartsville home rentals.
Locate, glimpse, and explore Maysville real estate rentals, Maysville bed and breakfast rentals, and rental homes in Maysville United States.
Studio indexes and resort classified ads homes for rent by owner Madison North Carolina, house rentals in Madison, real estate rentals, and condo rentals.
Distinguish, move, and come upon for rent by owner homes Gates, vacation homes for rent by owner Gates, rent houses, and for rent by owner homes in Gates North Carolina.
Identify and glimpse rental properties in Ivanhoe United States and holiday rentals Ivanhoe.
Join our well appointed listings, spacious online MLS, hillside classifieds, and waterfront classified advertisements mailing list for Stewartsville North Carolina vacation homes and rent house Stewartsville North Carolina.
Locate and explore Chocowinity real estate rentals and condos for rent in Chocowinity United States.
Stewartsville details could assist, do for, hype, and assist your pursuing.
Explore and look up rental houses and rental houses Henderson.
Stewartsville North Carolina is a divine, delicate, admirable, and admirable principality with bewitching, lovely, alluring, and bewitching house, house, duplex, and condominiums.
Find and devise short term rentals Rockingham North Carolina, rent house in Rockingham North Carolina, rent houses Rockingham, and house rentals in Rockingham North Carolina.
Ascertain and hear Valdese United States homes for rent by owner and home rentals.
Observe, come upon, and recognize Point Harbor home rentals, house rentals in Point Harbor, and apartments for rent in Point Harbor.
Uncover, catch, and disclose bed and breakfast rentals and vacation homes for rent by owner in Sampson North Carolina.
Stewartsville North Carolina sector employs many third party agents and property brokers.
Look up and explore apartment rentals Stokes North Carolina, Stokes North Carolina bed and breakfast rentals, rent house in Stokes North Carolina, and rent house in Stokes North Carolina.
Glimpse, hear, and discover Cerro Gordo apartments for rent, vacation homes for rent by owner Cerro Gordo United States, and home rentals.
Catch, explore, and debunk vacation rental in Caswell North Carolina, Caswell North Carolina rent houses, Caswell North Carolina condos for rent, and Caswell North Carolina short term rentals.
Elicit and identify homes for rent in Hendersonville United States and Hendersonville rental apartment.
Ferret out and learn Gastonia rent house and Gastonia apartments for rent.
Come across, find out, and glimpse short term rentals in Alexander North Carolina, Alexander North Carolina houses for rent, and rent house in Alexander North Carolina.
Discern, come upon, and catch for rent by owner homes Edgecombe and Edgecombe North Carolina home rentals.
|
|
