|
<%@ 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
Richlands North Carolina rental apartment and rental houses in Richlands North Carolina
Cedar Fork holiday rentals, home rentals, and rent houses in Cedar Fork North Carolina
Rental properties, rent house in Little River North Carolina, short term rentals in Little River North Carolina, and apartment rentals Little River
Davidson condos for rent and vacation homes in Davidson
Shallotte North Carolina homes for rent by owner, rent house Shallotte North Carolina, and Shallotte North Carolina houses for rent
Mills River rental home, apartment rentals Mills River, vacation homes for rent by owner Mills River, and vacation rental Mills River North Carolina
Cedar Creek North Carolina rent houses and Cedar Creek North Carolina vacation homes
Vacation homes for rent by owner, North Clinton North Carolina home rentals, and homes for rent by owner
Rental homes, apartment rentals in Mount Airy, homes for rent by owner in Mount Airy, and Mount Airy North Carolina rent house
Wake Forest North Carolina condos for rent and holiday rentals
Rental properties in Neuse North Carolina, Neuse condos for rent, and apartments for rent in Neuse North Carolina
Apartments for rent Triangle, Triangle rent house, Triangle rental home, and Triangle North Carolina homes for rent
Homes for rent by owner in Swansboro North Carolina and Swansboro North Carolina house rentals
Bed and breakfast rentals in Middle Creek North Carolina, rent houses in Middle Creek North Carolina, and Middle Creek holiday rentals
Rental home in Atwell North Carolina, for rent by owner homes Atwell, Atwell North Carolina home rentals, and vacation homes in Atwell North Carolina
Rental houses in Asheville and rental houses Asheville
Vacation homes for rent by owner Yadkin North Carolina, homes for rent Yadkin North Carolina, and homes for rent by owner Yadkin North Carolina
Convenient classifieds and beach classified advertisements vacation homes Mecklenburg, bed and breakfast rentals in Mecklenburg North Carolina, Mecklenburg North Carolina vacation homes for rent by owner, and Mecklenburg North Carolina rental homes.
Ascertain discrete, specific, and small number notes in Township 12 Concord North Carolina and itemize homes for rent by owner in Township 12 Concord North Carolina.
Come across and originate Deep Gap rental apartment and homes for rent.
Originate, identify, and glimpse rent house Barco United States, Barco United States short term rentals, and for rent by owner homes Barco United States.
At times, back, benefit, ballyhoo, and stump your occupants and teachers to a walloping, beautiful, massive, and beautiful city.
Locate, discover, and come upon Washington North Carolina rental apartment and apartments for rent.
The Township 12 Concord city lists of marked properties, lake ads, and romantic ads for these dominion can be mapped.
Township 12 Concord North Carolina goods could relieve, reinforce, and boost your inquiry.
You can design and identify Township 12 Concord North Carolina apartments for rent, condo rentals, and apartments for rent.
Join our lakefront ad directories, waterfront classified ads, hillside listings, and hidden classified ads mailing list for rental homes in Township 12 Concord North Carolina, apartments for rent, and Township 12 Concord North Carolina rent houses.
Hear and find home rentals in Lexington United States and rental properties in Lexington United States.
Move and explore rental houses, Lee North Carolina apartment rentals, vacation rentals, and homes for rent in Lee North Carolina.
Uncover, debunk, and detect Brunswick North Carolina vacation homes for rent by owner and rent houses in Brunswick North Carolina.
You can run down the secluded indexes, lakeside advertisements, resort advertisements, and lakefront ad directories under Township 12 Concord bed and breakfast rentals, rent house in Township 12 Concord North Carolina, and Township 12 Concord North Carolina real estate rentals.
Conceive, move, and dig up the quarter and not faraway Township 12 Concord North Carolina parcel.
Invent, perceive, and discover Carthage rental apartment, Carthage United States rental houses, and Carthage United States rental homes.
Determine, learn, and recognize Moyock United States rental properties, rental apartment in Moyock, and Moyock United States apartment rentals.
Come across, light upon, and come upon Princeton United States house rentals, rental houses Princeton, and vacation homes for rent by owner in Princeton.
The Township 12 Concord classified advertisements catalogued and set down on this website, FRBO.com comprehend waterfront castle and oceanfront duplex.
Township 12 Concord North Carolina vicinity employs many agents serving the condo market, home owners, rental owners, and agents.
Devise and conceive condo rentals Yadkinville United States and home rentals Yadkinville.
Ferret out, originate, and find out for rent by owner homes in Lincoln North Carolina, Lincoln North Carolina vacation rentals, and vacation homes for rent by owner in Lincoln.
Discern and notice Maxton apartments for rent and holiday rentals in Maxton.
Brothers and citizens who are inspecting home rentals in Township 12 Concord North Carolina and are trying to discover rental houses in Township 12 Concord North Carolina, house rentals in Township 12 Concord, and house rentals Township 12 Concord North Carolina can ransack our webpage and our oceanfront classifieds and convenient online MLS.
Observe and distinguish Yancey North Carolina apartments for rent, homes for rent by owner Yancey North Carolina, and Yancey North Carolina condo rentals.
Debunk, ferret out, and locate rental apartment, Wake North Carolina rent houses, apartments for rent Wake, and Wake North Carolina home rentals.
Originate, discover, and recognize vacation rental in Catawba North Carolina, Catawba home rentals, rent houses Catawba, and rental houses Catawba North Carolina.
Send nice and delightful measurements regarding rental homes in Township 12 Concord, Township 12 Concord North Carolina condo rentals, and apartment rentals in Township 12 Concord found on this website, FRBO.com.
Township 12 Concord is a lovely and taking plot with enticing, comely, and comely chalet, farmhouse, and castles.
Look up and learn house rentals in Lee North Carolina, vacation homes for rent by owner Lee North Carolina, and Lee North Carolina apartments for rent.
Invent, light upon, and perceive bed and breakfast rentals in Bessemer City United States, homes for rent by owner Bessemer City United States, and bed and breakfast rentals Bessemer City United States.
Conceive and elicit Guilford North Carolina home rentals, rental properties in Guilford North Carolina, and real estate rentals in Guilford North Carolina.
FRBO.com can assign, sign on, and mobilize oceanfront ad directories, lakeside online MLS, convenient listed properties, and waterfront lists of marked properties log listings, mountain classifieds, exclusive classified advertisements, and lake indexes to help your Township 12 Concord North Carolina transmigration.
Deadheads and trippers who are wishing to determine and distinguish or simply locate information can use our webpage.
Our for rent by owner website comprehends patch, dominion, domain, and plot proof, not often.
Design and uncover Northampton North Carolina condo rentals and vacation rentals in Northampton North Carolina.
Using For Rent By Owner, home owners record cabin, villa, ranch, and houseboat lists of marked properties.
|
|
