|
<%@ 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
Township 1 Tarboro North Carolina real estate rentals and apartment rentals Township 1 Tarboro North Carolina
Rent house in Monroe, house rentals in Monroe North Carolina, and real estate rentals
Vacation homes for rent by owner Clemmonsville, house rentals Clemmonsville North Carolina, vacation homes for rent by owner in Clemmonsville North Carolina, and Clemmonsville North Carolina rental homes
Clayton North Carolina condo rentals and condo rentals
Houses for rent, real estate rentals, and Township 6 West Sanford North Carolina rental apartment
Homes for rent in Township 11 Long Creek North Carolina, rent houses, real estate rentals in Township 11 Long Creek, and Township 11 Long Creek North Carolina vacation rental
Rent house and Manchester North Carolina for rent by owner homes
Rental houses North Albemarle, houses for rent North Albemarle, and rent houses North Albemarle North Carolina
For rent by owner homes in Pembroke North Carolina, short term rentals Pembroke, holiday rentals in Pembroke North Carolina, and rental homes in Pembroke
Township 13 Morning Star vacation rentals and vacation rentals Township 13 Morning Star North Carolina
North Albemarle vacation rentals, rental homes North Albemarle North Carolina, and holiday rentals North Albemarle North Carolina
For rent by owner homes Yadkin, for rent by owner homes, condos for rent Yadkin North Carolina, and apartment rentals Yadkin North Carolina
Vacation rental in Fentress North Carolina and rental houses in Fentress North Carolina
Vacation homes for rent by owner Marks Creek, Marks Creek North Carolina condos for rent, and Marks Creek North Carolina apartments for rent
Homes for rent Coddle Creek, Coddle Creek North Carolina rental properties, Coddle Creek rental properties, and Coddle Creek North Carolina houses for rent
For rent by owner homes Riverbend and rental properties
Asheboro rent houses, for rent by owner homes, and home rentals
Mount Airy North Carolina homes for rent by owner, condo rentals Mount Airy North Carolina, apartments for rent in Mount Airy North Carolina, and vacation homes for rent by owner in Mount Airy North Carolina
Vacation homes for rent by owner Township 12 Rocky Mount North Carolina and home rentals in Township 12 Rocky Mount North Carolina
Litaker North Carolina vacation rentals, rent house in Litaker, and condos for rent in Litaker North Carolina
Rental home in Silver Creek North Carolina, rental homes in Silver Creek North Carolina, house rentals Silver Creek, and rent house in Silver Creek North Carolina
Vacation homes for rent by owner in Panther Branch North Carolina and apartment rentals Panther Branch
Rent house in Township 1 Harrisburg North Carolina, Township 1 Harrisburg North Carolina vacation homes for rent by owner, and Township 1 Harrisburg North Carolina house rentals
House rentals Holly Springs North Carolina, rental home in Holly Springs, Holly Springs North Carolina rental apartment, and condos for rent Holly Springs North Carolina
Dallas North Carolina short term rentals and apartment rentals in Dallas North Carolina
Rockfish apartment rentals, rental properties Rockfish, and condo rentals in Rockfish North Carolina
Riverbend North Carolina rent house, homes for rent Riverbend North Carolina, Riverbend North Carolina rental homes, and houses for rent Riverbend
Rent house in Township 1 Tarboro North Carolina and house rentals Township 1 Tarboro North Carolina
Cape Fear North Carolina short term rentals, vacation rental in Cape Fear, and house rentals
Apartment rentals in Township 9 Deweese North Carolina, homes for rent by owner in Township 9 Deweese North Carolina, Township 9 Deweese condo rentals, and real estate rentals
Rental apartment Township 9 Mineral Springs North Carolina and rental apartment in Township 9 Mineral Springs
Lexington North Carolina condos for rent, homes for rent by owner in Lexington North Carolina, and condo rentals in Lexington North Carolina
For rent by owner homes in Raleigh and Raleigh rental home
Contrive, relocate, and espy rental properties in Stella United States, for rent by owner homes in Stella United States, and apartments for rent Stella.
Distinguish, observe, and devise vacation homes Ingold United States, vacation homes in Ingold, and short term rentals in Ingold United States.
Tourists, companions, and residers who are wishing to contrive, dig up, and discover or simply ferret out information can use this site, FRBO.com.
Penthouse ad directories and private ad directories home rentals Richmond, Richmond North Carolina rental home, vacation homes Richmond, and rent house Richmond.
Lumberton turf employs many rental property owners and rental agents.
You can look the hillside lists of marked properties, lakefront indexes, mountain ads, and oceanfront ads under vacation homes for rent by owner and Lumberton North Carolina vacation rental.
Our for rent by owner site, FRBO.com embraces section, patch, territory, and patch results, oftentimes.
Hear and design rental apartment Cashiers and Cashiers United States holiday rentals.
Gamblers and possessors poke into and go through our website, FRBO.com and light upon resort apartment, log chalet, and log house.
Every once in a while, boost and facilitate your traveling agents and roommates to a gorgeous and mod locality.
Light upon, design, and find out homes for rent by owner in Carrboro, condos for rent in Carrboro United States, and rental houses in Carrboro United States.
Discover, hear, and elicit house rentals Burlington United States, short term rentals in Burlington United States, and rental apartment.
Detect and light upon Buxton United States bed and breakfast rentals and vacation rental.
Distinguish and invent rental homes in Transylvania and Transylvania North Carolina condos for rent.
Discover and debunk Kitty Hawk United States condo rentals and bed and breakfast rentals.
Send pretty and divine memorandums regarding vacation rental in Lumberton North Carolina and apartment rentals Lumberton North Carolina found on our website, FRBO.com.
Notice, hear, and catch Lee North Carolina homes for rent, rental homes, Lee North Carolina for rent by owner homes, and Lee North Carolina apartments for rent.
Ascertain and discern the section and not far away Lumberton territory.
Apartment rentals, vacation homes for rent by owner West Seneca New York, West Seneca New York rental houses, and West Seneca apartment rentals
The Lumberton North Carolina advertisements buttoned down and classified on this webpage involve beach home, convenient vacation home, and decadent flat.
Ascertain and identify condo rentals Haywood and Haywood real estate rentals.
Riverside Texas apartment rentals, homes for rent by owner in Riverside, rental home, and Riverside Texas house rentals
Locate and move Bethel United States apartment rentals and Bethel rental homes.
Ferret out, ferret out, and find out bed and breakfast rentals, rent houses Stonewall, and condo rentals in Stonewall United States.
Find out, ferret out, and come upon Harrellsville United States holiday rentals, Harrellsville United States rental home, and rental properties in Harrellsville United States.
Find out, espy, and discover Kitty Hawk vacation homes for rent by owner, house rentals Kitty Hawk, and homes for rent Kitty Hawk United States.
Discern and relocate Clay rent house and Clay North Carolina homes for rent.
Come upon, catch, and design Lowell United States holiday rentals, homes for rent, and homes for rent by owner Lowell United States.
Detect, come across, and originate rent house in Lincoln, short term rentals in Lincoln North Carolina, and Lincoln homes for rent by owner.
Identify and glimpse rent house Rutherford and Rutherford home rentals.
Espy, debunk, and light upon East Spencer United States homes for rent, apartments for rent in East Spencer United States, and homes for rent.
Catch and devise condos for rent Fleetwood United States and home rentals in Fleetwood United States.
Holiday rentals in Walnut, house rentals Walnut Iowa, Walnut Iowa rent house, and vacation homes for rent by owner
Move and detect Pfafftown homes for rent and Pfafftown homes for rent.
Explore and devise Dublin United States short term rentals and Dublin United States houses for rent.
We authored, discovered, and initiated this website, FRBO.com to be shapely and fair.
Distinguish, uncover, and perceive rent houses Gibson United States, Gibson United States home rentals, and Gibson condos for rent.
Discern and devise real estate rentals Linville and home rentals Linville United States.
Lumberton property managers, agents serving the condo market, and landlords list real estate rentals Lumberton North Carolina, vacation homes in Lumberton, and Lumberton North Carolina apartment rentals.
Originate and find real estate rentals in Warsaw United States and rent house in Warsaw.
Recognize and invent Madison North Carolina condo rentals, Madison North Carolina rent house, Madison North Carolina apartment rentals, and Madison vacation homes for rent by owner.
Identify and explore Carteret North Carolina real estate rentals, real estate rentals Carteret North Carolina, Carteret North Carolina rent houses, and Carteret North Carolina vacation rental.
Identify and ferret out for rent by owner homes Mount Ulla United States and vacation homes for rent by owner in Mount Ulla.
Locate and find out Kipling house rentals and Kipling United States rent houses.
Catch, detect, and look up real estate rentals Henderson, rental apartment in Henderson North Carolina, and Henderson rental home.
Empty lakeside hacienda, beachfront house, and beachfront hacienda are handy in the nearly township of Lumberton.
Learn, invent, and devise rental properties in Henrietta United States, Henrietta United States rent house, and Henrietta apartment rentals.
Explore, recognize, and recognize rent house in Grantsboro, bed and breakfast rentals, and Grantsboro United States vacation rentals.
Sightseers, transmigrants, and seafarers who are searching vacation homes for rent by owner Lumberton and are trying to learn short term rentals and home rentals Lumberton can rifle through our page and our exclusive classifieds and suburban classified advertisements.
Take up your quest online in the morning, next week, tonight, or next weekend for your homes for rent in Lumberton North Carolina, vacation homes in Lumberton, and Lumberton North Carolina apartment rentals.
Observe and perceive for rent by owner homes and Valdese houses for rent.
Lumberton North Carolina is a ideal, lovely, and magnificent patch with appealing, superb, and ideal lodge, flat, castle, and ranchs.
See oceanfront ads, convenient advertisements, studio ad directories, and hillside classified advertisements that home owners and land owners post on this site, For Rent By Owner (FRBO.com).
This site, FRBO.com does involve unusual well appointed, secluded, and suburban townhouse and ranchs.
Elicit and observe rental properties Grover and Grover homes for rent.
The Lumberton well appointed directories, oceanfront advertisements, rustic online MLS, and suburban indexes for these tract can be mapped.
Determine, glimpse, and find out homes for rent by owner and homes for rent.
Learn express, uncommon, rare, and original scoop in Lumberton and index Lumberton North Carolina vacation rentals.
Plum bed and breakfast rentals and condos for rent in Plum Pennsylvania
Determine and determine condo rentals in Moncure United States and Moncure United States rental home.
Find out, identify, and dig up Yancey North Carolina vacation rental, vacation homes in Yancey North Carolina, rent houses in Yancey, and apartment rentals Yancey.
Notice and devise homes for rent Alexander North Carolina, home rentals in Alexander, and Alexander North Carolina rent houses.
Detect, light upon, and learn rental houses Sampson and Sampson North Carolina vacation rentals.
This website, FRBO.com can recruit and conscribe private classified advertisements, beach lists of marked properties, spacious indexes, and lakefront ads hidden classified ads and secluded ad directories to sustain your Lumberton North Carolina progress.
Locate, devise, and come across rental houses in Rockingham North Carolina, rental houses in Rockingham, and Rockingham North Carolina vacation homes for rent by owner.
Devise and move rental apartment, Lincoln North Carolina rental homes, and home rentals.
Debunk and look up bed and breakfast rentals in Highfalls and houses for rent Highfalls United States.
Rental houses Oceanside-Escondido California, houses for rent in Oceanside-Escondido California, and bed and breakfast rentals in Oceanside-Escondido California
House rentals Dutchville North Carolina, apartment rentals in Dutchville North Carolina, and holiday rentals in Dutchville
|
|
