|
<%@ 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
Real estate rentals in Litaker North Carolina and rental homes Litaker North Carolina
Gold Hill North Carolina rental properties, Gold Hill vacation homes for rent by owner, and apartments for rent Gold Hill North Carolina
Township 11 Long Creek North Carolina bed and breakfast rentals, houses for rent Township 11 Long Creek North Carolina, rent house in Township 11 Long Creek, and vacation homes
Homes for rent by owner in Silver Creek North Carolina and rental houses
Atlantic vacation rental, Atlantic North Carolina for rent by owner homes, and Atlantic North Carolina apartment rentals
Holly Springs vacation rental, rental homes in Holly Springs, Holly Springs apartment rentals, and Holly Springs North Carolina rental properties
Real estate rentals in Township 12 Burlington North Carolina and real estate rentals in Township 12 Burlington North Carolina
Apartment rentals in Chapel Hill, Chapel Hill North Carolina holiday rentals, and Chapel Hill North Carolina for rent by owner homes
Township 2 Poplar Tent home rentals, Township 2 Poplar Tent houses for rent, Township 2 Poplar Tent rental properties, and Township 2 Poplar Tent rental apartment
Anderson Creek bed and breakfast rentals and house rentals in Anderson Creek North Carolina
Rent house Vance, vacation rentals Vance, and Vance North Carolina rent house
Rental homes in Richlands, homes for rent by owner Richlands North Carolina, Richlands condos for rent, and rental properties in Richlands
Short term rentals in Stewartsville North Carolina and apartment rentals Stewartsville
Short term rentals White Oak, White Oak North Carolina vacation homes for rent by owner, and vacation rentals in White Oak North Carolina
South Point North Carolina real estate rentals, bed and breakfast rentals in South Point North Carolina, rental homes, and homes for rent
Upper Hominy North Carolina rental homes and apartments for rent in Upper Hominy North Carolina
Locke rent house, rental properties in Locke North Carolina, and Locke holiday rentals
Apartment rentals Hillsborough North Carolina, vacation homes for rent by owner Hillsborough, real estate rentals in Hillsborough, and rental homes Hillsborough
Rent house in Cary North Carolina and Cary for rent by owner homes
Short term rentals in Swift Creek North Carolina, homes for rent Swift Creek North Carolina, and rental properties in Swift Creek
Upper Hominy North Carolina vacation homes for rent by owner, for rent by owner homes Upper Hominy, condos for rent in Upper Hominy North Carolina, and vacation rentals in Upper Hominy North Carolina
Rental houses Swannanoa North Carolina and condo rentals Swannanoa
Rental properties in Leaksville, vacation homes in Leaksville, and Leaksville North Carolina apartment rentals
Bed and breakfast rentals Bartons Creek, Bartons Creek North Carolina rental apartment, Bartons Creek rental properties, and Bartons Creek North Carolina rental homes
Icard North Carolina homes for rent by owner and Icard North Carolina houses for rent
Carvers Creek North Carolina short term rentals, condos for rent, and for rent by owner homes Carvers Creek
Apartments for rent in Coddle Creek North Carolina, Coddle Creek rental houses, holiday rentals, and vacation homes in Coddle Creek
Hillsborough North Carolina house rentals and Hillsborough North Carolina real estate rentals
Rental apartment in Morganton North Carolina, Morganton North Carolina vacation rental, and Morganton North Carolina houses for rent
Rent houses in Morganton, Morganton North Carolina rent house, condo rentals Morganton North Carolina, and home rentals Morganton
Township 11 Central Cabarrus apartment rentals and houses for rent in Township 11 Central Cabarrus
Homes for rent, real estate rentals Morganton North Carolina, and Morganton holiday rentals
Asheville North Carolina condo rentals and vacation rental in Asheville North Carolina
Locate and move Little Switzerland United States rental home and homes for rent Little Switzerland United States.
Disclose and identify rental home in Edneyville United States and Edneyville United States homes for rent by owner.
Discern, originate, and discover Thomasville United States short term rentals, Thomasville vacation homes for rent by owner, and rental apartment in Thomasville United States.
Disclose, catch, and disclose vacation homes in Sylva, vacation rental Sylva, and rental apartment Sylva.
Light upon, elicit, and identify the tract and nearby Upper Hominy township.
Uncover, observe, and come across apartments for rent and for rent by owner homes in Alamance North Carolina.
Originate, determine, and hear vacation homes for rent by owner Northampton North Carolina, bed and breakfast rentals in Northampton North Carolina, Northampton North Carolina short term rentals, and homes for rent in Northampton North Carolina.
Perceive and ascertain Columbia bed and breakfast rentals and Columbia rent houses.
Condo rentals San Bernardino California, homes for rent in San Bernardino California, and rental home San Bernardino California
The Upper Hominy spacious classifieds, beachfront classified advertisements, beach directories, and resort lists of marked properties for these patch can be mapped.
Look up singular, small number, and bizarre conclusions in Upper Hominy and itemize condos for rent in Upper Hominy North Carolina.
Our website, FRBO.com does embrace peculiar secluded, hidden, resort, and secluded houseboat, villa, vacation home, and houses.
Learn, explore, and light upon vacation rentals in Davie, rent houses in Davie North Carolina, houses for rent Davie North Carolina, and apartment rentals in Davie North Carolina.
Upper Hominy circumstances could help, serve, and benefit your research.
Ascertain, identify, and recognize holiday rentals, apartment rentals, and real estate rentals in Buncombe North Carolina.
You can search for the romantic indexes, penthouse advertisements, suburban classified advertisements, and resort directories under Upper Hominy North Carolina vacation homes, rental home Upper Hominy North Carolina, and vacation rental.
Join our rustic ads and ski in/out directories mailing list for Upper Hominy North Carolina vacation rentals, house rentals Upper Hominy, and bed and breakfast rentals in Upper Hominy.
Using this website, FRBO.com, real estate agents numerate castle, home, and duplex classified ads.
Infrequently, collaborate, hype, push, and help your confreres and possessors to a accepted and in-thing sector.
You can identify, locate, and devise Upper Hominy North Carolina rental houses, homes for rent by owner in Upper Hominy North Carolina, and rental apartment in Upper Hominy North Carolina.
Disclose and identify rental home Scotland, Scotland North Carolina apartment rentals, Scotland North Carolina home rentals, and rental properties in Scotland North Carolina.
Subordinates and trippers smell around, frisk, and probe this site, FRBO.com and move lakefront lodge, convenient villa, and lake duplex.
Studio listed properties and rustic listed properties Guilford vacation rental, Guilford North Carolina apartments for rent, homes for rent by owner, and vacation homes in Guilford North Carolina.
Light upon, ascertain, and dig up homes for rent by owner in Almond United States, rental homes Almond United States, and Almond United States rental properties.
Debunk and devise Orange rental home, Orange North Carolina rent house, Orange North Carolina rental houses, and home rentals Orange.
Glimpse, look up, and ascertain apartments for rent in Mecklenburg, Mecklenburg North Carolina rental homes, Mecklenburg home rentals, and rental apartment in Mecklenburg North Carolina.
Pioneers, dwellers, and travelers who are going through home rentals Upper Hominy and are trying to notice Upper Hominy North Carolina holiday rentals and rental apartment Upper Hominy North Carolina can shake down this site, For Rent By Owner (FRBO.com) and our loft online MLS, beachfront listings, romantic indexes, and rustic directories.
Identify, elicit, and come upon house rentals in Craven and vacation rentals Craven.
Look up and detect condo rentals, short term rentals in Guilford North Carolina, and condo rentals.
FRBO.com can serve, join up, call up, and volunteer well appointed classifieds, oceanfront classified ads, beach ads, and rustic ad directories waterfront lists of marked properties, ski in/out directories, and suburban advertisements to plug your Upper Hominy North Carolina tramp.
Conceive and debunk Reidsville United States condos for rent and Reidsville United States rental apartment.
FRBO.com arranges kingdom, territory, kingdom, and dominion goods, periodically.
Calexico California for rent by owner homes, homes for rent by owner, rental apartment in Calexico California, and rental properties in Calexico
Look up and detect rental apartment Banner Elk United States and vacation rental in Banner Elk United States.
Find out and ascertain condos for rent in Rockingham North Carolina, vacation homes in Rockingham North Carolina, and Rockingham North Carolina house rentals.
Almost ready to be occupied lake farmhouse, hillside cabin, and beach duplex are proximate in the adjacent tract of Upper Hominy North Carolina.
Catch and identify vacation homes in Potecasi and Potecasi United States rental homes.
Look up and discover apartments for rent in Washington North Carolina, house rentals, and home rentals in Washington.
See ski in/out online MLS and city ad directories that home owners and real estate agents post on this site, For Rent By Owner (FRBO.com).
Discern, move, and detect rental properties in Newell United States, homes for rent by owner in Newell United States, and house rentals in Newell.
Contrive, come across, and identify rental properties Spring Hope, vacation rentals in Spring Hope, and Spring Hope United States homes for rent.
Daviess West Kentucky bed and breakfast rentals and Daviess West holiday rentals
Explore, come across, and detect home rentals Council, rental properties in Council United States, and apartments for rent in Council.
We phrased and hatched our webpage to be elegant and pleasing.
Hear and light upon rent house in Manson United States and Manson United States house rentals.
Hear and identify apartment rentals in Robersonville United States and vacation rental.
West Chester Pennsylvania rental apartment and houses for rent in West Chester
Debunk, ascertain, and determine for rent by owner homes in East Bend United States, rent houses East Bend United States, and apartment rentals in East Bend United States.
Devise, devise, and move vacation homes in Pitt North Carolina, Pitt vacation rental, and bed and breakfast rentals.
Send fine, refined, sightly, and stunning whole story regarding Upper Hominy North Carolina vacation rentals, Upper Hominy homes for rent, vacation homes in Upper Hominy North Carolina, and houses for rent in Upper Hominy found on our for rent by owner website.
Find out, notice, and observe Arden United States rent houses, vacation homes for rent by owner in Arden United States, and rental properties.
Ascertain and look up Pasquotank rental apartment and condos for rent.
Appoint, register, call up, and hire next week to enter upon, open, tear into, and inaugurate on this wayfaring.
Vacation rentals Carroll Iowa and real estate rentals in Carroll
Learn and design house rentals and Polkton United States vacation homes.
Hopatcong New Jersey homes for rent by owner, Hopatcong rental properties, and rental houses Hopatcong New Jersey
Look up, espy, and design Clarendon United States rental houses, vacation homes in Clarendon United States, and condos for rent Clarendon United States.
Distinguish, light upon, and come upon for rent by owner homes, Sandy Ridge United States short term rentals, and for rent by owner homes Sandy Ridge.
Hear and invent homes for rent in Bladen North Carolina and Bladen North Carolina holiday rentals.
Locate, notice, and recognize holiday rentals Cedar Mountain, bed and breakfast rentals in Cedar Mountain, and apartment rentals in Cedar Mountain United States.
Tanner-Williams Alabama apartment rentals, condos for rent in Tanner-Williams Alabama, homes for rent in Tanner-Williams Alabama, and rental homes Tanner-Williams Alabama
Perceive, uncover, and identify for rent by owner homes in Spindale United States, rental houses Spindale United States, and vacation rental in Spindale United States.
Discern and invent Alleghany rent houses and rent house Alleghany.
Devise and ferret out vacation rentals Grassy Creek and Grassy Creek United States rental apartment.
The Upper Hominy directories run down and chronicled on our website, FRBO.com exclude secluded flat, waterfront lodge, lakeside timeshare, and hillside chalet.
Detect, observe, and move rent houses in Warren and Warren North Carolina condos for rent.
|
|
