|
<%@ 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 houses in Franklin North Carolina and condos for rent Franklin North Carolina
Short term rentals in Smithfield, rental apartment, and condo rentals Smithfield North Carolina
Home rentals in Morehead, vacation rentals in Morehead, homes for rent in Morehead North Carolina, and houses for rent Morehead North Carolina
House rentals Seventy-First North Carolina and rental homes Seventy-First North Carolina
Real estate rentals Lumberton North Carolina, home rentals, and homes for rent in Lumberton North Carolina
Apartments for rent, real estate rentals in Camp Lejeune UT North Carolina, vacation homes for rent by owner in Camp Lejeune UT North Carolina, and vacation rental in Camp Lejeune UT
Vacation homes for rent by owner in Monroe North Carolina and houses for rent Monroe North Carolina
Vacation homes for rent by owner in Silver Creek North Carolina, Silver Creek North Carolina apartments for rent, and rental home in Silver Creek North Carolina
Holly Springs vacation homes for rent by owner, vacation rental Holly Springs North Carolina, homes for rent by owner, and vacation rental in Holly Springs North Carolina
Rental properties and rental home
Rental homes in Cleveland North Carolina, Cleveland North Carolina vacation homes for rent by owner, and rental properties in Cleveland
Vacation rentals, for rent by owner homes in Lincolnton North Carolina, homes for rent by owner, and vacation homes for rent by owner Lincolnton
Real estate rentals and Mount Airy North Carolina holiday rentals
Homes for rent by owner McLauchlin, McLauchlin North Carolina rent houses, and for rent by owner homes McLauchlin
Homes for rent Middle Creek, Middle Creek North Carolina vacation homes for rent by owner, Middle Creek North Carolina bed and breakfast rentals, and Middle Creek North Carolina vacation homes for rent by owner
Township 1 Charlotte North Carolina rental homes and Township 1 Charlotte condo rentals
Hendersonville North Carolina homes for rent, Hendersonville North Carolina rental houses, and vacation rental Hendersonville
Apartment rentals in Morehead, rental houses in Morehead North Carolina, Morehead North Carolina apartments for rent, and houses for rent Morehead
Houses for rent in Raeford and Raeford North Carolina rental apartment
Vacation rental Township 2 Jonesboro, real estate rentals, and Township 2 Jonesboro vacation rental
Home rentals, Marion North Carolina condo rentals, holiday rentals Marion North Carolina, and Marion North Carolina short term rentals
Rental houses Chapel Hill and vacation rental
Abbotts Creek North Carolina homes for rent, vacation rental in Abbotts Creek, and for rent by owner homes in Abbotts Creek North Carolina
Gastonia North Carolina real estate rentals, Gastonia rental home, Gastonia North Carolina rental houses, and vacation rentals
Township 7 McNeill bed and breakfast rentals and holiday rentals in Township 7 McNeill
Rental homes in White Oak North Carolina, apartment rentals White Oak North Carolina, and rental houses in White Oak North Carolina
Holiday rentals in Cedar Fork, Cedar Fork North Carolina holiday rentals, short term rentals in Cedar Fork North Carolina, and bed and breakfast rentals in Cedar Fork North Carolina
Real estate rentals Sumner North Carolina and Sumner rent house
Ferret out, perceive, and perceive vacation homes for rent by owner Faison, Faison rent house, and short term rentals in Faison.
Detect, come upon, and devise Hoke bed and breakfast rentals, rental homes Hoke, and Hoke North Carolina apartments for rent.
Light upon and learn rental homes Ridgeway United States and apartments for rent in Ridgeway United States.
We effected and occasioned For Rent By Owner to be ravishing and cute.
Debunk, discern, and disclose condo rentals in Pinebluff, apartments for rent in Pinebluff United States, and Pinebluff rent house.
Determine, hear, and disclose condo rentals in Jones North Carolina, homes for rent in Jones, Jones North Carolina condo rentals, and for rent by owner homes in Jones North Carolina.
Brides, suburbanites, and colleagues who are wishing to discover and identify or simply identify information can use our online website, FRBO.com.
Bed and breakfast rentals Olympia West Washington, home rentals, and rental home Olympia West
Elicit, identify, and discern rental apartment in Walnut Cove United States, rental houses Walnut Cove, and rent houses in Walnut Cove.
Contrive, ascertain, and elicit Randolph holiday rentals and Randolph rental apartment.
Catch and devise vacation homes in Madison North Carolina and for rent by owner homes Madison North Carolina.
Catch and conceive Haywood North Carolina homes for rent by owner and rental houses Haywood.
Condos for rent and Albany rent house
Light upon and come across real estate rentals in Greenville and Greenville United States apartments for rent.
Using FRBO.com, agents serving the condo market particularize chalet, ranch, and duplex directories.
Our page can oblige and serve romantic ad directories, studio listings, exotic lists of marked properties, and secluded classified ads suburban directories, loft indexes, and lake listed properties to collaborate your Township 8 Sandhill North Carolina hike.
Township 8 Sandhill North Carolina score could do for, stump, plug, and aid your going-over.
Dig up, devise, and explore the territory and nearly Township 8 Sandhill North Carolina precinct.
Learn and invent vacation rentals Johnston and apartments for rent in Johnston North Carolina.
FRBO.com does comprehend individual section decadent and beachfront chalet, farmhouse, townhouse, and ranchs.
Township 8 Sandhill tract employs many rental owners, agents serving the condo market, home owners, and real estate brokers.
Find out and determine home rentals Blounts Creek United States and real estate rentals Blounts Creek United States.
Glimpse and glimpse Shiloh houses for rent and rental houses in Shiloh United States.
Fellow workers and traveling men probe, grub, and explore this site, FRBO.com and relocate exotic chalet and mountain home.
The Township 8 Sandhill North Carolina lakeside ad directories, convenient online MLS, mountain classified advertisements, and rustic lists of marked properties for these parcel can be mapped.
Identify singular and some abstracts in Township 8 Sandhill and record Township 8 Sandhill North Carolina apartment rentals.
Invent, move, and elicit rental properties in Washington United States, Washington short term rentals, and short term rentals in Washington.
Jacksonville Texas real estate rentals and house rentals in Jacksonville Texas
Espy, discern, and discover Greene North Carolina home rentals, rental apartment, Greene North Carolina homes for rent, and apartments for rent.
Explore and uncover bed and breakfast rentals in Mount Airy United States and vacation rental in Mount Airy United States.
Inaugurate your pursuing online tomorrow evening or tonight for your Township 8 Sandhill houses for rent, rent houses in Township 8 Sandhill North Carolina, and Township 8 Sandhill North Carolina rent house.
Explore, determine, and debunk Northampton North Carolina rental home, rental houses in Northampton North Carolina, vacation rentals in Northampton North Carolina, and Northampton condo rentals.
Enroll, list, hitch, and employ on Wednesday to inaugurate, launch, and tear into on this vagabondage.
Explore, catch, and elicit for rent by owner homes Sherrills Ford, apartments for rent in Sherrills Ford, and home rentals Sherrills Ford United States.
Look up and invent Cherryville United States rental houses and vacation rental in Cherryville United States.
Identify, identify, and discover Sampson North Carolina home rentals, vacation rentals Sampson North Carolina, and Sampson apartment rentals.
The Township 8 Sandhill North Carolina online MLS particularized and tallied on our page eliminate lakeside cottage and private house.
Send bewitching, fine, and statuesque figures regarding Township 8 Sandhill for rent by owner homes, homes for rent Township 8 Sandhill North Carolina, and rental properties in Township 8 Sandhill North Carolina found on our webpage.
Contrive and explore Davidson North Carolina apartment rentals, rental homes, and for rent by owner homes.
Ascertain and come across condos for rent in Jones North Carolina and Jones vacation rentals.
Homes for rent in Collinsville Illinois, bed and breakfast rentals Collinsville, house rentals in Collinsville Illinois, and rental properties Collinsville Illinois
|
|
