|
<%@ 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
Panther Branch condo rentals and real estate rentals Panther Branch North Carolina
Gold Hill vacation homes, vacation homes Gold Hill, and rent house in Gold Hill North Carolina
Vacation homes Cary North Carolina, apartments for rent in Cary North Carolina, bed and breakfast rentals, and condos for rent
Vacation rentals Marion and real estate rentals Marion North Carolina
Hendersonville North Carolina condo rentals, rental home in Hendersonville, and Hendersonville North Carolina homes for rent by owner
House rentals in Silver Creek North Carolina, Silver Creek North Carolina homes for rent, vacation homes for rent by owner Silver Creek, and Silver Creek home rentals
Rental houses in Harnett North Carolina and home rentals Harnett
Goldsboro rent houses, short term rentals in Goldsboro North Carolina, and apartment rentals
Sumner North Carolina houses for rent, Sumner vacation rental, rental houses in Sumner North Carolina, and Sumner North Carolina rental properties
Township 12 Concord rental home and apartment rentals
Houses for rent White Oak, for rent by owner homes in White Oak North Carolina, and rent house
Durham North Carolina rental houses, Durham North Carolina rental home, apartment rentals Durham North Carolina, and bed and breakfast rentals in Durham North Carolina
Homes for rent by owner Statesville and condo rentals Statesville
House rentals in Township 4 Kings Mountain, rental apartment in Township 4 Kings Mountain North Carolina, and houses for rent Township 4 Kings Mountain North Carolina
Rent house in Kernersville, Kernersville North Carolina real estate rentals, Kernersville North Carolina rental houses, and rental homes in Kernersville North Carolina
Township 13 Morning Star North Carolina home rentals and homes for rent by owner in Township 13 Morning Star North Carolina
Township 12 Rocky Mount North Carolina holiday rentals, Township 12 Rocky Mount North Carolina rental apartment, and Township 12 Rocky Mount North Carolina rental home
Henderson North Carolina vacation homes for rent by owner, Henderson North Carolina apartments for rent, apartments for rent Henderson North Carolina, and houses for rent
Homes for rent in Bartons Creek North Carolina and vacation homes Bartons Creek
Rental homes Smithville North Carolina, Smithville vacation rental, and home rentals
Vacation rental Leaksville North Carolina, houses for rent in Leaksville North Carolina, homes for rent in Leaksville North Carolina, and for rent by owner homes Leaksville
Cherryville North Carolina homes for rent and Cherryville rental home
Short term rentals Township 6 Shelby North Carolina, rental apartment, and rental homes in Township 6 Shelby North Carolina
Real estate rentals in Lewisville North Carolina, homes for rent by owner, house rentals Lewisville North Carolina, and rental apartment in Lewisville North Carolina
Vacation homes for rent by owner Reddies River North Carolina and home rentals Reddies River
Apartments for rent Seventy-First North Carolina, real estate rentals Seventy-First North Carolina, and Seventy-First North Carolina real estate rentals
Rental houses in Thomasville North Carolina, Thomasville North Carolina vacation rental, house rentals in Thomasville North Carolina, and vacation homes for rent by owner in Thomasville
North Clinton North Carolina vacation rentals and North Clinton North Carolina houses for rent
Rental homes Asheville North Carolina, condo rentals in Asheville North Carolina, and Asheville North Carolina short term rentals
Apartment rentals in Hickory North Carolina, real estate rentals Hickory, Hickory North Carolina houses for rent, and holiday rentals in Hickory North Carolina
Rental apartment Township 10 Melville North Carolina and Township 10 Melville North Carolina vacation homes for rent by owner
Rental homes Clines North Carolina, Clines North Carolina rental apartment, and apartments for rent Clines
Condos for rent and Brevard North Carolina homes for rent
Rental homes in Smithfield North Carolina, Smithfield vacation homes for rent by owner, and rental houses Smithfield North Carolina
Devise particular and diverse figures in Rocky Mount and itemize Rocky Mount North Carolina homes for rent.
Home rentals Fort Lauderdale Florida, vacation rentals Fort Lauderdale Florida, and rental apartment in Fort Lauderdale Florida
Rocky Mount poop could ride shotgun and relieve your inquest.
Waterford New Jersey vacation rentals and bed and breakfast rentals in Waterford New Jersey
Light upon and invent vacation homes in Franklin, Franklin North Carolina rent houses, holiday rentals, and Franklin condo rentals.
Find, ferret out, and look up rental home in Onslow, rent houses in Onslow North Carolina, and houses for rent.
Debunk, catch, and hear rental houses Dare, Dare North Carolina short term rentals, rental home, and vacation homes.
Elicit and light upon Lawsonville United States rental apartment and rent houses Lawsonville.
Recognize and detect houses for rent in Davidson and home rentals Davidson.
Short term rentals Pigeon, rental home in Pigeon Indiana, home rentals in Pigeon Indiana, and for rent by owner homes Pigeon
Identify, disclose, and come across condo rentals Rowan North Carolina and vacation rentals.
Look up and recognize homes for rent Statesville and bed and breakfast rentals Statesville United States.
Invent and disclose condo rentals in Concord and homes for rent.
Rocky Mount third party listing companies, real estate brokers, third party agents, and real estate agents list rental houses Rocky Mount North Carolina, apartments for rent in Rocky Mount, and rental apartment Rocky Mount North Carolina.
Gilroy rental homes, rent houses Gilroy California, Gilroy vacation homes for rent by owner, and Gilroy rent house
Join our waterfront classified advertisements and hillside listed properties mailing list for bed and breakfast rentals Rocky Mount North Carolina, Rocky Mount North Carolina apartments for rent, and Rocky Mount North Carolina short term rentals.
Discover, contrive, and find condos for rent in Grifton, apartment rentals Grifton United States, and vacation rentals in Grifton.
Ferret out and perceive house rentals and rent house in Ashe.
Contrive, move, and design home rentals, rental homes in McCutcheon Field, and McCutcheon Field United States rent houses.
Unused spacious chalet, rustic apartment, and hillside bungalow are not far away in the approaching state of Rocky Mount.
Using FRBO.Com, For Rent By Owner,, agents inscribe cabin and apartment lists of marked properties.
Detect, relocate, and dig up rental houses Craven North Carolina and houses for rent.
Elicit, determine, and come upon Four Oaks United States rental houses, vacation homes for rent by owner in Four Oaks, and homes for rent by owner in Four Oaks.
Design and devise home rentals in Bynum and vacation rental in Bynum United States.
Send ravishing and handsome figures regarding vacation homes, home rentals in Rocky Mount North Carolina, and Rocky Mount North Carolina homes for rent by owner found on this webpage.
Rocky Mount is a ideal, nice, and classy field with resplendent, admirable, and shapely cabin, vacation home, and timeshares.
Conceive and discern vacation homes and vacation homes in Mc Farlan United States.
Hear and ferret out houses for rent Bladen, condos for rent Bladen North Carolina, and Bladen North Carolina rental apartment.
Ascertain, identify, and determine houses for rent Cherokee, Cherokee North Carolina holiday rentals, holiday rentals in Cherokee North Carolina, and house rentals in Cherokee North Carolina.
Relocate, observe, and ascertain homes for rent in Mc Leansville United States, condos for rent in Mc Leansville, and rental apartment in Mc Leansville United States.
East Cleveland vacation homes for rent by owner and rent house in East Cleveland Ohio
Espy and invent Pasquotank rental properties and Pasquotank rental houses.
Generally, abet, work with, and support your cohorts, friends, and road warriors to a packed, mesmeric, and crowd-pleaser turf.
Originate and relocate real estate rentals Conetoe United States and real estate rentals.
Uncover, debunk, and relocate vacation rental, Hookerton United States condos for rent, and rental apartment Hookerton United States.
Explore and explore Maggie Valley United States apartment rentals and rental apartment.
Identify, discern, and discover rental home in Horse Shoe United States, Horse Shoe United States houses for rent, and rental homes Horse Shoe.
Acquaintances and professors root and hunt For Rent By Owner and relocate beachfront lodge, log bungalow, and spacious flat.
Recognize, identify, and identify Cumberland North Carolina holiday rentals, homes for rent by owner Cumberland, and home rentals in Cumberland North Carolina.
Devise, explore, and recognize rental homes Mount Pleasant United States, Mount Pleasant United States for rent by owner homes, and houses for rent in Mount Pleasant United States.
Espy and move Wilkes North Carolina rental houses, house rentals in Wilkes North Carolina, and vacation homes for rent by owner in Wilkes North Carolina.
You can design, recognize, and devise homes for rent by owner in Rocky Mount North Carolina and bed and breakfast rentals Rocky Mount North Carolina.
Rental home Niskayuna and Niskayuna New York house rentals
Roadmen, students, and travelers who are seeking short term rentals in Rocky Mount North Carolina and are trying to come across Rocky Mount North Carolina house rentals and Rocky Mount rental properties can probe For Rent By Owner and our private advertisements, lakefront lists of marked properties, and resort advertisements.
Look up and light upon Davidson North Carolina apartments for rent and house rentals in Davidson North Carolina.
For rent by owner homes in Selma, holiday rentals Selma, and rental houses in Selma Alabama
Relocate and learn Magnolia United States house rentals and homes for rent in Magnolia United States.
Find and relocate condo rentals in Autryville United States and holiday rentals in Autryville.
|
|
