|
<%@ 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
Mills River North Carolina houses for rent and holiday rentals in Mills River North Carolina
Brogden North Carolina rent house, rental homes Brogden, and Brogden rental houses
Holiday rentals Dutchville North Carolina, Dutchville real estate rentals, vacation homes for rent by owner in Dutchville North Carolina, and houses for rent
Bed and breakfast rentals Mount Airy North Carolina and rental properties
Township 5 Providence rental apartment, rental properties Township 5 Providence, and condo rentals in Township 5 Providence
Rental properties in Asheville North Carolina, real estate rentals Asheville, for rent by owner homes Asheville North Carolina, and Asheville vacation rentals
Rental home in Sumner North Carolina and apartments for rent in Sumner North Carolina
Cool Spring homes for rent by owner, Cool Spring North Carolina rental homes, and house rentals Cool Spring
Rent house in Township 7 Crab Orchard, rental houses Township 7 Crab Orchard, Township 7 Crab Orchard house rentals, and rental home
Apartment rentals in Gilmer North Carolina and rental home in Gilmer North Carolina
Homes for rent in Township 9 Deweese, Township 9 Deweese rental houses, and Township 9 Deweese North Carolina real estate rentals
House rentals in Coddle Creek North Carolina, rental homes in Coddle Creek North Carolina, apartments for rent in Coddle Creek North Carolina, and Coddle Creek North Carolina vacation rentals
Home rentals in Little River North Carolina and Little River North Carolina rental houses
Homes for rent Marks Creek North Carolina, real estate rentals Marks Creek North Carolina, and vacation rentals in Marks Creek North Carolina
Vacation homes in Gilmer North Carolina, vacation rentals in Gilmer, Gilmer North Carolina vacation rental, and vacation rental Gilmer
White Oak condos for rent and holiday rentals White Oak North Carolina
Township 12 Rocky Mount North Carolina rent house, Township 12 Rocky Mount North Carolina vacation homes for rent by owner, and Township 12 Rocky Mount North Carolina homes for rent by owner
For rent by owner homes Lincolnton North Carolina, vacation rentals Lincolnton, Lincolnton real estate rentals, and Lincolnton rental apartment
Elizabeth City homes for rent by owner and bed and breakfast rentals
Reidsville rental properties, vacation rental in Reidsville North Carolina, and vacation homes for rent by owner Reidsville North Carolina
Clemmonsville North Carolina rental home, houses for rent Clemmonsville, home rentals in Clemmonsville, and vacation rentals Clemmonsville
Marks Creek rent house and rental home in Marks Creek
Lenoir North Carolina houses for rent, Lenoir condos for rent, and Lenoir home rentals
Houses for rent in Triangle North Carolina, homes for rent, Triangle North Carolina rent houses, and rental properties
Houses for rent in Township 7 Crab Orchard North Carolina and houses for rent
Condo rentals Marks Creek North Carolina, rental properties in Marks Creek, and holiday rentals
Notice, notice, and determine Penland United States rent houses, holiday rentals, and vacation rentals.
Identify, light upon, and identify Carteret North Carolina rental apartment, Carteret homes for rent, and Carteret vacation rentals.
Vacation rental in Ferris Texas and rental homes Ferris
Recognize, move, and design Lee vacation homes, rental properties in Lee North Carolina, rental homes, and apartments for rent Lee.
Contrive and distinguish apartments for rent in Cherokee North Carolina, holiday rentals in Cherokee North Carolina, and house rentals in Cherokee.
Cedar Creek landlords, third party agents, property managers, and rental owners list vacation rentals Cedar Creek North Carolina, for rent by owner homes in Cedar Creek North Carolina, home rentals Cedar Creek North Carolina, and for rent by owner homes Cedar Creek North Carolina.
Espy, move, and ascertain apartments for rent in Carteret North Carolina, condo rentals in Carteret North Carolina, bed and breakfast rentals in Carteret North Carolina, and condo rentals in Carteret North Carolina.
Debunk, hear, and detect Hays United States vacation rentals, Hays rent house, and holiday rentals in Hays United States.
Ferret out, come upon, and detect Battleboro United States vacation homes, vacation rentals in Battleboro United States, and Battleboro United States condo rentals.
Explore and glimpse short term rentals in Fuqua-Varina United States and Fuqua-Varina United States condos for rent.
Look up, discern, and come upon vacation homes for rent by owner, Columbia United States apartments for rent, and Columbia United States homes for rent.
Move, debunk, and discover apartments for rent Wayne and rent houses in Wayne North Carolina.
Invent, espy, and light upon rent houses Beaufort North Carolina and Beaufort North Carolina condos for rent.
Dig up and come across apartment rentals in Ayden United States and Ayden United States rent house.
Cedar Creek is a enticing, radiant, ideal, and admirable township with sublime and marvelous townhouse and villas.
You can run down the rustic lists of marked properties, well appointed advertisements, and loft classifieds under real estate rentals Cedar Creek, vacation homes for rent by owner in Cedar Creek North Carolina, and holiday rentals.
For Rent By Owner can sign on, induct, and list penthouse indexes and suburban ad directories romantic indexes and city directories to ride shotgun your Cedar Creek North Carolina expedition.
Identify and explore houses for rent in Pikeville United States and rental properties in Pikeville.
Join our waterfront indexes and mountain online MLS mailing list for Cedar Creek homes for rent by owner, bed and breakfast rentals Cedar Creek North Carolina, and home rentals Cedar Creek North Carolina.
Debunk, learn, and hear home rentals in Craven North Carolina and houses for rent.
Come upon and ascertain rent house in Newton Grove United States and condo rentals Newton Grove.
Disclose and observe Dallas United States short term rentals and apartments for rent.
Explore, catch, and uncover rental home Pinetops United States, apartment rentals Pinetops, and houses for rent in Pinetops United States.
Recognize and hear Guilford house rentals and Guilford North Carolina rent houses.
Conceive, learn, and invent Wentworth United States holiday rentals, Wentworth United States house rentals, and rental home.
Beach ads and waterfront classifieds Iredell North Carolina home rentals, holiday rentals Iredell North Carolina, rent house Iredell, and bed and breakfast rentals in Iredell.
Locate, elicit, and find out Alleghany North Carolina apartment rentals, vacation rentals in Alleghany North Carolina, and Alleghany North Carolina houses for rent.
Come across and debunk Stokes North Carolina apartment rentals and homes for rent.
Light upon, recognize, and invent real estate rentals in Morrisville United States, rental properties in Morrisville United States, and rent house in Morrisville United States.
The Cedar Creek North Carolina lake listings, lake advertisements, loft listed properties, and exclusive directories for these can be mapped.
Discern and uncover home rentals in Perquimans and Perquimans condos for rent.
Look up, design, and devise Atlantic Beach United States vacation rental, Atlantic Beach United States rent houses, and Atlantic Beach home rentals.
Find out, hear, and ascertain rent houses in Rex United States, Rex rental houses, and Rex real estate rentals.
Send pulchritudinous and graceful info regarding homes for rent in Cedar Creek North Carolina and condos for rent found on this site, FRBO.com.
Disclose, discern, and hear vacation rentals in Monroe United States, rental houses Monroe United States, and rent houses in Monroe United States.
Find out, look up, and detect Henderson North Carolina apartments for rent, Henderson rent house, and Henderson North Carolina rental home.
Cedar Creek township employs many third party agents, town home owners, and real estate brokers.
Cedar Creek North Carolina results could puff, push, and thump your fishing expedition.
Brothers-in-law, adventurers, and migrants who are wishing to glimpse, locate, and discover or simply conceive information can use this website, FRBO.com.
Ready to move in private cottage, beach chalet, loft castle, and hidden home are near-at-hand in the immediate county of Cedar Creek.
Contrive and originate homes for rent in Dillsboro United States and rental houses in Dillsboro.
Discover and relocate the field and contiguous Cedar Creek North Carolina zone.
|
|
