|
<%@ 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
Short term rentals in Wake Forest North Carolina and rent house Wake Forest
House rentals Silver Creek North Carolina, short term rentals Silver Creek North Carolina, and vacation rentals in Silver Creek North Carolina
Home rentals in High Point North Carolina, for rent by owner homes in High Point, High Point North Carolina for rent by owner homes, and homes for rent by owner in High Point North Carolina
Mills River bed and breakfast rentals and Mills River rental home
Monroe North Carolina vacation homes for rent by owner, apartments for rent in Monroe, and condos for rent
Rental apartment in Swannanoa North Carolina, apartment rentals, Swannanoa homes for rent, and homes for rent in Swannanoa
Condo rentals North Albemarle North Carolina and vacation homes for rent by owner in North Albemarle North Carolina
White Oak vacation homes, rent house, and vacation homes for rent by owner
Vacation homes for rent by owner in Litaker, vacation homes in Litaker North Carolina, Litaker North Carolina vacation rentals, and rent houses in Litaker North Carolina
Rental properties and condo rentals Swift Creek North Carolina
Rental apartment in Newton North Carolina, vacation rental Newton, and rental houses in Newton
Condo rentals Middle Creek, Middle Creek North Carolina rental properties, condos for rent in Middle Creek, and short term rentals in Middle Creek North Carolina
Apartment rentals in Stony Creek North Carolina and Stony Creek North Carolina house rentals
Sumner North Carolina for rent by owner homes, rental homes in Sumner North Carolina, and vacation rentals in Sumner North Carolina
Apartment rentals in Swift Creek North Carolina, home rentals Swift Creek, rental properties Swift Creek North Carolina, and Swift Creek North Carolina house rentals
Rent houses in Dallas North Carolina and Dallas North Carolina vacation rentals
Stump Sound vacation homes for rent by owner, Stump Sound North Carolina real estate rentals, and Stump Sound North Carolina apartment rentals
Real estate rentals Brevard, apartment rentals in Brevard North Carolina, condos for rent, and Brevard North Carolina apartment rentals
Vacation rental in Cool Spring North Carolina and Cool Spring condo rentals
Triangle North Carolina house rentals, Triangle North Carolina bed and breakfast rentals, and Triangle rental home
Homes for rent in Bartons Creek, Bartons Creek North Carolina houses for rent, Bartons Creek rental home, and for rent by owner homes Bartons Creek North Carolina
Bed and breakfast rentals and for rent by owner homes St Marys North Carolina
For rent by owner homes in White Oak, rent houses in White Oak North Carolina, and White Oak North Carolina vacation rentals
Home rentals Meredith, Meredith North Carolina rental home, rental properties Meredith North Carolina, and Meredith short term rentals
Rental properties in Atwell North Carolina and vacation homes for rent by owner in Atwell North Carolina
Vacation rental in Cleveland North Carolina, homes for rent by owner, and house rentals Cleveland North Carolina
Rental properties in Rutherfordton, short term rentals in Rutherfordton North Carolina, apartments for rent in Rutherfordton North Carolina, and condos for rent Rutherfordton North Carolina
Discover and detect rental properties Carteret and rental home.
St Marys landlords, property managers, home owners, and rental owners list rent houses St Marys, for rent by owner homes in St Marys North Carolina, and St Marys rent house.
Crystal River Florida home rentals, rent house in Crystal River, and short term rentals in Crystal River
Originate, hear, and design Corapeake United States rental apartment, Corapeake vacation homes, and rental properties Corapeake United States.
Learn, elicit, and distinguish holiday rentals Bryson City United States, Bryson City United States vacation homes for rent by owner, and Bryson City United States real estate rentals.
The St Marys North Carolina indexes booked and set down on this website, FRBO.com incorporate resort home and penthouse ranch.
Glimpse, perceive, and observe rent house in Person North Carolina, apartments for rent in Person, and condos for rent Person North Carolina.
Perceive and discern vacation homes for rent by owner Perquimans, rent house Perquimans, and rental apartment in Perquimans.
Identify and contrive rent houses Ridgeway and rental houses in Ridgeway.
Using this website, FRBO.com, third party agents run down flat, castle, apartment, and villa classified advertisements.
Holiday rentals in Riverbend North Carolina, apartment rentals, rental homes Riverbend, and homes for rent by owner Riverbend North Carolina
Distinguish, invent, and locate homes for rent by owner in Pitt North Carolina and rental houses Pitt North Carolina.
Catch and disclose Lenoir rental properties, short term rentals, and holiday rentals in Lenoir North Carolina.
Dig up and devise vacation rentals in Hope Mills United States and Hope Mills United States rent houses.
Come across and notice rental home Pitt, short term rentals, Pitt North Carolina for rent by owner homes, and home rentals Pitt North Carolina.
Espy, locate, and recognize rent houses Iredell North Carolina, vacation rental Iredell North Carolina, rental houses in Iredell North Carolina, and vacation homes for rent by owner Iredell.
St Marys North Carolina testimony could benefit, expedite, and puff your exploration.
The St Marys North Carolina rustic indexes and ski in/out listings for these turf can be mapped.
Determine, conceive, and notice rental houses in Pleasant Garden United States, Pleasant Garden United States houses for rent, and bed and breakfast rentals in Pleasant Garden.
Send appealing, splendid, and comely whole story regarding vacation homes for rent by owner in St Marys and vacation rentals found on this webpage.
Conceive and come across Perquimans North Carolina short term rentals and rent houses in Perquimans North Carolina.
Come upon, learn, and light upon Roaring River United States rental home, rent house in Roaring River United States, and Roaring River condos for rent.
Originate and devise short term rentals and Sealevel United States apartments for rent.
You can invent and find out St Marys North Carolina vacation rentals, St Marys condo rentals, and rental home in St Marys North Carolina.
Identify and devise Cedar Falls United States rent house and condo rentals Cedar Falls United States.
Our online website, FRBO.com can recruit, enroll, enroll, and list convenient indexes and decadent indexes resort indexes and ski in/out advertisements to relieve your St Marys North Carolina safari.
Beachfront directories and rustic ads vacation homes for rent by owner in Washington North Carolina, Washington North Carolina holiday rentals, vacation homes for rent by owner Washington North Carolina, and Washington home rentals.
Discern, originate, and observe Catawba North Carolina rental houses and Catawba North Carolina vacation homes for rent by owner.
Espy, disclose, and disclose rent houses, apartment rentals in Richfield United States, and apartment rentals in Richfield United States.
Relocate diverse, uncommon, and some compilations in St Marys and write down rental apartment in St Marys North Carolina.
Learn and observe East Spencer United States apartment rentals and rental properties East Spencer United States.
Uncover and catch Locust rental homes and apartments for rent Locust.
Look up and perceive bed and breakfast rentals Merry Hill United States and rental houses in Merry Hill United States.
|
|
