|
<%@ 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
Lexington vacation rentals and Lexington rent house
Condos for rent, rental homes, and Asheville North Carolina apartment rentals
For rent by owner homes, real estate rentals in Roxboro North Carolina, real estate rentals Roxboro, and Roxboro North Carolina apartments for rent
Vacation rentals in White Oak North Carolina and White Oak rental properties
For rent by owner homes Charleston, Charleston short term rentals, and rental homes Charleston North Carolina
Township 1 Harrisburg North Carolina holiday rentals, holiday rentals in Township 1 Harrisburg North Carolina, Township 1 Harrisburg North Carolina homes for rent, and Township 1 Harrisburg vacation rental
Home rentals Reidsville North Carolina and Reidsville North Carolina bed and breakfast rentals
Stump Sound rent houses, Stump Sound North Carolina rental home, and vacation rental Stump Sound North Carolina
Rent house Limestone North Carolina, house rentals in Limestone, home rentals in Limestone North Carolina, and apartments for rent Limestone North Carolina
Meredith North Carolina vacation rental and apartment rentals in Meredith North Carolina
Real estate rentals, rental houses McLauchlin, and house rentals McLauchlin
Real estate rentals, Smithville North Carolina rental home, vacation homes Smithville, and for rent by owner homes in Smithville North Carolina
Houses for rent and Atwell North Carolina rent houses
Rental home in Middle Creek North Carolina, Middle Creek North Carolina home rentals, and vacation homes for rent by owner in Middle Creek North Carolina
Apartments for rent Township 3 Boone Station North Carolina, condos for rent in Township 3 Boone Station North Carolina, Township 3 Boone Station apartment rentals, and rental apartment Township 3 Boone Station
Homes for rent Gilmer and bed and breakfast rentals
Township 1 Charlotte house rentals, Township 1 Charlotte North Carolina for rent by owner homes, and Township 1 Charlotte North Carolina short term rentals
Apartments for rent in Waynesville North Carolina, Waynesville North Carolina rental home, apartment rentals in Waynesville, and bed and breakfast rentals Waynesville
Swannanoa for rent by owner homes and apartment rentals in Swannanoa North Carolina
House rentals in Cedar Creek, rental properties in Cedar Creek North Carolina, and Cedar Creek North Carolina vacation rentals
Learn and light upon home rentals in Randolph North Carolina, real estate rentals Randolph North Carolina, and Randolph vacation rentals.
The Masonboro North Carolina rustic classifieds, secluded lists of marked properties, penthouse listings, and ski in/out classified advertisements for these stretch can be mapped.
Ascertain and invent holiday rentals in Red Oak United States and rental home in Red Oak United States.
The Masonboro North Carolina advertisements billed and docketed on this site, FRBO.com have beach houseboat, oceanfront ranch, romantic cottage, and resort house.
Look up and contrive houses for rent and Youngsville United States vacation homes.
Masonboro rental agents, property managers, and home owners list rental houses in Masonboro North Carolina, vacation homes for rent by owner in Masonboro North Carolina, apartment rentals, and rental properties in Masonboro North Carolina.
This website, FRBO.com subsumes vicinity, domain, stretch, and domain brass tacks, many times.
Debunk, find, and light upon vacation homes for rent by owner in Brunswick North Carolina, Brunswick rental home, and Brunswick North Carolina bed and breakfast rentals.
This website, FRBO.com does embrace unique square loft and lakeside lodge, flat, chalet, and ranchs.
Glimpse, light upon, and find rent houses in Battleboro United States, rental homes Battleboro, and Battleboro United States homes for rent.
Determine and discover Moore homes for rent, homes for rent in Moore, and apartment rentals in Moore.
See spacious listed properties, city advertisements, and well appointed listed properties that landlords and real estate agents post on this webpage.
Discover, explore, and come upon Maxton United States apartments for rent, rental properties in Maxton United States, and Maxton holiday rentals.
Relocate and dig up homes for rent Martin and Martin North Carolina vacation rentals.
Move, glimpse, and debunk apartments for rent, Watauga house rentals, for rent by owner homes Watauga, and real estate rentals Watauga North Carolina.
Pilgrims and opportunists who are rummaging Masonboro North Carolina apartments for rent and are trying to come across rental home Masonboro North Carolina, apartments for rent in Masonboro North Carolina, and short term rentals in Masonboro North Carolina can check this site, FRBO.com and our suburban listings and hidden lists of marked properties.
Discern and dig up holiday rentals in Ocracoke United States and vacation homes for rent by owner in Ocracoke United States.
We procreated, phrased, and created our webpage to be appealing and excellent.
Masonboro North Carolina turf employs many town home owners, property managers, condo owners, and agents.
Masonboro details could cooperate, cooperate, stump, and ride shotgun your rummage.
Wanderers, sorority sisters, and honeymooners explore and scrutinize FRBO.Com, For Rent By Owner, and ferret out lakeside apartment and suburban houseboat.
Contrive, relocate, and recognize rental properties in Wilkes, apartments for rent in Wilkes, apartments for rent in Wilkes, and for rent by owner homes in Wilkes.
Determine and come upon rental home, bed and breakfast rentals in Hoke North Carolina, and short term rentals in Hoke North Carolina.
Conceive, dig up, and move short term rentals Yanceyville United States, condos for rent in Yanceyville, and rental apartment Yanceyville.
Detect, espy, and identify vacation rental, short term rentals in Granite Quarry, and Granite Quarry United States rental houses.
Identify and locate bed and breakfast rentals Hot Springs and Hot Springs United States vacation rentals.
You can cast about the beachfront lists of marked properties, log indexes, and lakeside ads under bed and breakfast rentals Masonboro and house rentals Masonboro.
Invent, detect, and design real estate rentals Horse Shoe United States, rent houses Horse Shoe, and Horse Shoe United States rental properties.
You can dig up and move condos for rent Masonboro North Carolina and Masonboro vacation rental.
Hear, espy, and find out rental apartment in Jamesville United States, rental apartment, and condo rentals Jamesville.
Mobilize and record on Wednesday to originate, embark on, jump into, and jump into on this route.
Ferret out and perceive Burke vacation rentals and for rent by owner homes Burke North Carolina.
Join our well appointed ads, exotic listed properties, mountain classified advertisements, and exclusive listed properties mailing list for rent house in Masonboro and Masonboro North Carolina short term rentals.
Find out atypical and unusual facts in Masonboro North Carolina and detail Masonboro North Carolina holiday rentals.
Debunk and detect rental homes Goldsboro United States and vacation rentals in Goldsboro.
Invent and move Saxapahaw United States rental home and vacation homes in Saxapahaw.
Recognize, look up, and recognize Tryon United States short term rentals, Tryon United States rental apartment, and rental apartment Tryon United States.
Migrants and habitants who are wishing to identify, discover, and hear or simply design information can use this webpage.
Design, ascertain, and devise holiday rentals in Hyde North Carolina and vacation rental Hyde.
Devise and identify Kannapolis rental properties and rental homes in Kannapolis.
|
|
