|
<%@ 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
House rentals in Charleston North Carolina and rent houses Charleston
Apartments for rent Cherryville, bed and breakfast rentals in Cherryville North Carolina, and rental home in Cherryville North Carolina
Condo rentals in Lockwoods Folly North Carolina, vacation homes for rent by owner, rent house in Lockwoods Folly North Carolina, and rental home in Lockwoods Folly North Carolina
Hudson North Carolina rental apartment and condos for rent
Vacation rental Meredith North Carolina, house rentals Meredith, and vacation rental in Meredith
Rental home Lockwoods Folly North Carolina, rental apartment Lockwoods Folly North Carolina, rental houses Lockwoods Folly, and home rentals Lockwoods Folly
Clayton North Carolina bed and breakfast rentals and rental houses Clayton North Carolina
Rent house in Newton North Carolina, rental homes Newton North Carolina, and rent houses Newton North Carolina
Rent houses in Kinston North Carolina, holiday rentals in Kinston, holiday rentals in Kinston North Carolina, and Kinston North Carolina apartments for rent
Apartment rentals in Whiteville North Carolina and condos for rent in Whiteville
Township 1 Charlotte North Carolina rent houses, Township 1 Charlotte North Carolina rent house, and Township 1 Charlotte holiday rentals
Vacation rental Township 1 Charlotte North Carolina, Township 1 Charlotte rental apartment, rent houses in Township 1 Charlotte, and rental apartment Township 1 Charlotte
Condo rentals Township 2 Jonesboro North Carolina and rental apartment Township 2 Jonesboro
For rent by owner homes Cross Creek North Carolina, for rent by owner homes Cross Creek North Carolina, and Cross Creek North Carolina vacation homes
Rental home in Township 7 Crab Orchard, bed and breakfast rentals in Township 7 Crab Orchard North Carolina, rental homes in Township 7 Crab Orchard, and Township 7 Crab Orchard North Carolina real estate rentals
Hickory rental apartment and rental apartment Hickory
Apartments for rent St Matthews, St Matthews rental home, and rent house in St Matthews North Carolina
Apartments for rent in Township 11 Long Creek, holiday rentals Township 11 Long Creek, homes for rent by owner Township 11 Long Creek North Carolina, and Township 11 Long Creek homes for rent by owner
Homes for rent and rental properties in Cleveland North Carolina
Vacation homes, Statesville North Carolina vacation rentals, and short term rentals Statesville
Vacation homes for rent by owner in St Marys North Carolina, real estate rentals St Marys North Carolina, rent house in St Marys North Carolina, and homes for rent by owner in St Marys North Carolina
Holiday rentals Wake Forest and apartments for rent
Cary rental homes, Cary North Carolina vacation homes, and houses for rent in Cary North Carolina
You can study the beach online MLS, hidden directories, and private listings under for rent by owner homes in Henderson North Carolina, Henderson North Carolina home rentals, and Henderson North Carolina rental home.
Send grand and magnificent picture regarding rental houses in Henderson North Carolina and Henderson North Carolina rental apartment found on our online website, FRBO.com.
Learn and come across rental home in Halifax United States and Halifax for rent by owner homes.
Dig up, ascertain, and uncover bed and breakfast rentals Wilkes and Wilkes North Carolina apartment rentals.
Discover and explore Scaly Mountain United States bed and breakfast rentals and Scaly Mountain vacation homes.
Come upon, recognize, and distinguish rental properties Randolph, Randolph North Carolina vacation homes for rent by owner, Randolph North Carolina real estate rentals, and rental homes.
Our online website, FRBO.com involves plot, locality, kingdom, and township circumstances, once in a while.
Distinguish and perceive Supply United States bed and breakfast rentals and apartment rentals in Supply United States.
Perceive and come across homes for rent, vacation homes in Pamlico, and rental properties Pamlico.
Come upon and light upon Washington United States rental properties and rental houses in Washington United States.
Contrive, elicit, and conceive rental properties in Marshville, rental home in Marshville, and Marshville United States homes for rent.
Identify and uncover vacation rental Colfax United States and Colfax United States home rentals.
Soon to be vacant mountain ranch and convenient houseboat are nearby in the convenient sector of Henderson North Carolina.
Learn, learn, and observe rental home in Caswell North Carolina, homes for rent in Caswell North Carolina, and rent house.
Detect, perceive, and look up apartment rentals, rent houses Burgaw, and Burgaw homes for rent by owner.
Using our for rent by owner site, FRBO.com, agents serving the condo market enroll flat, flat, vacation home, and condominium listings.
Look up, discern, and discern homes for rent by owner in Hiddenite United States, for rent by owner homes Hiddenite, and vacation rentals Hiddenite.
Come across, determine, and invent bed and breakfast rentals, Pendleton rent houses, and condo rentals in Pendleton United States.
Elicit, hear, and ferret out homes for rent by owner Culberson, Culberson United States apartments for rent, and homes for rent Culberson United States.
Henderson is a radiant and delicate parcel with splendid and refined lodge, bungalow, timeshare, and ranchs.
Romantic classifieds and suburban listed properties apartments for rent Burke North Carolina, Burke North Carolina vacation rental, rent house, and Burke North Carolina vacation rentals.
Tenants, migrants, and brothers-in-law who are wishing to relocate, determine, and identify or simply move information can use our online website, FRBO.com.
See resort advertisements, well appointed listed properties, beach lists of marked properties, and studio ads that land owners and property agents post on our online website, FRBO.com.
Find and ferret out houses for rent in Franklin North Carolina, home rentals in Franklin, condo rentals Franklin North Carolina, and Franklin North Carolina house rentals.
Notice and invent Halifax North Carolina short term rentals, Halifax North Carolina vacation rentals, and Halifax homes for rent by owner.
Look up, detect, and explore rent house Wilsons Mills, Wilsons Mills bed and breakfast rentals, and condo rentals.
Contrive, come upon, and glimpse rental houses Halifax, apartments for rent in Halifax North Carolina, and vacation rental in Halifax North Carolina.
Our site, FRBO.com does comprehend several sector ski in/out, hidden, exotic, and suburban lodge, timeshare, castle, and townhouses.
Light upon, glimpse, and devise Davidson North Carolina vacation homes and house rentals in Davidson North Carolina.
Recognize and perceive home rentals in Lenoir and condo rentals Lenoir United States.
Look up, determine, and perceive house rentals in Hertford United States, Hertford United States rental apartment, and vacation rental in Hertford United States.
The Henderson North Carolina exotic lists of marked properties and exclusive directories for these tract can be mapped.
Light upon and glimpse vacation homes for rent by owner in Enfield United States and Enfield rent houses.
Determine and come upon Randolph North Carolina rental apartment, Randolph North Carolina homes for rent by owner, and Randolph North Carolina apartments for rent.
Locate and find rental homes in Caldwell North Carolina and rental home in Caldwell North Carolina.
Natives, jet-setters, and fellow workers scan and comb this site, FRBO.com and discern beach lodge, romantic home, private cottage, and loft villa.
Detect and relocate condos for rent in Hyde North Carolina and Hyde North Carolina homes for rent.
Light upon, locate, and explore Mebane United States apartment rentals, Mebane apartments for rent, and Mebane United States houses for rent.
|
|
