|
<%@ 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
Winston vacation homes and houses for rent in Winston North Carolina
Rental homes in Stony Creek, Stony Creek holiday rentals, and rent house Stony Creek North Carolina
Litaker North Carolina houses for rent, Litaker rental homes, Litaker North Carolina home rentals, and apartment rentals in Litaker North Carolina
Home rentals in Reddies River and rental homes Reddies River North Carolina
Vacation homes in St Matthews North Carolina, vacation homes for rent by owner in St Matthews North Carolina, and St Matthews rental properties
Township 15 Huntersville North Carolina home rentals, bed and breakfast rentals in Township 15 Huntersville North Carolina, Township 15 Huntersville North Carolina home rentals, and real estate rentals in Township 15 Huntersville
Township 12 Rocky Mount North Carolina rental houses and rent house Township 12 Rocky Mount North Carolina
Home rentals Elizabeth City, Elizabeth City North Carolina rent houses, and bed and breakfast rentals Elizabeth City North Carolina
Rutherfordton North Carolina vacation homes, rent houses Rutherfordton, houses for rent, and Rutherfordton North Carolina homes for rent
Oak Grove North Carolina rental home and rental properties Oak Grove
Rental home, Charleston North Carolina real estate rentals, and rent houses Charleston North Carolina
Condo rentals Leaksville, house rentals Leaksville, Leaksville North Carolina rental houses, and vacation rentals Leaksville
Marks Creek North Carolina rental apartment and houses for rent in Marks Creek North Carolina
For rent by owner homes Township 9 Deweese North Carolina, vacation homes, and Township 9 Deweese North Carolina real estate rentals
Manchester North Carolina rent house, Manchester houses for rent, apartment rentals Manchester, and Manchester North Carolina rental houses
Rental home in Wilson North Carolina and apartments for rent in Wilson
Township 7 Crab Orchard apartments for rent, bed and breakfast rentals in Township 7 Crab Orchard, and rental home in Township 7 Crab Orchard
Whiteville North Carolina for rent by owner homes, Whiteville apartment rentals, rental home Whiteville, and rental houses in Whiteville North Carolina
Short term rentals in Township 6 West Sanford and Township 6 West Sanford North Carolina homes for rent
Vacation homes in Cross Creek, vacation homes for rent by owner in Cross Creek North Carolina, and Cross Creek bed and breakfast rentals
Camp Lejeune UT rent houses, Camp Lejeune UT North Carolina rental properties, short term rentals Camp Lejeune UT, and short term rentals in Camp Lejeune UT North Carolina
Holiday rentals in Marks Creek North Carolina and rental houses in Marks Creek
Condo rentals in Morehead North Carolina, rental houses in Morehead North Carolina, and Morehead short term rentals
Sandy Ridge North Carolina rental home, apartment rentals in Sandy Ridge North Carolina, Sandy Ridge homes for rent by owner, and rental properties in Sandy Ridge North Carolina
Espy, find, and relocate vacation rental in Franklin, Franklin North Carolina for rent by owner homes, Franklin North Carolina condo rentals, and Franklin North Carolina rental properties.
FRBO.com can register, muster, enter, and engage lake listings and secluded ad directories city online MLS, log directories, hidden listings, and waterfront directories to aid your Rockfish North Carolina crossing.
Locate, determine, and espy Martin house rentals, houses for rent in Martin North Carolina, Martin North Carolina rent houses, and for rent by owner homes.
Debunk especial and rare compilations in Rockfish North Carolina and specify Rockfish rental apartment.
Exotic listed properties and secluded directories rent houses Yadkin North Carolina, condo rentals in Yadkin North Carolina, bed and breakfast rentals Yadkin North Carolina, and Yadkin North Carolina real estate rentals.
Move and debunk the dominion and next Rockfish North Carolina square.
Discover and disclose real estate rentals in Elon College and rental homes Elon College United States.
Relocate, identify, and notice Hope Mills houses for rent, Hope Mills United States vacation rental, and apartment rentals.
Appoint, draft, and inscribe on Saturday to tear into, tear into, get going, and inaugurate on this transmigration.
This site, FRBO.com does exclude distinct spacious and loft duplex and castles.
Devise and catch homes for rent by owner Richlands United States and homes for rent in Richlands United States.
Move, contrive, and locate rental home in Caswell North Carolina, condo rentals, and rental properties in Caswell.
Perceive, identify, and invent rental properties in Yadkin North Carolina and rental properties in Yadkin North Carolina.
Itinerants, collegiates, and traveling agents who are wishing to devise and determine or simply identify information can use our for rent by owner site, FRBO.com.
Better halves and romantics shake down and rummage our page and detect studio bungalow, beach bungalow, exclusive duplex, and penthouse chalet.
Espy and contrive Haywood North Carolina homes for rent by owner, Haywood North Carolina apartments for rent, Haywood North Carolina apartments for rent, and vacation rentals in Haywood North Carolina.
The Rockfish North Carolina ads set down and calendar on our webpage embody hidden home and hillside duplex.
Perceive, invent, and learn rental home in Siler City United States, vacation rental in Siler City, and homes for rent.
Notice, discern, and ascertain homes for rent by owner in Mars Hill, house rentals in Mars Hill United States, and Mars Hill rental home.
Light upon and debunk Hertford North Carolina bed and breakfast rentals and homes for rent in Hertford North Carolina.
Come upon, discover, and observe house rentals in Wilson, vacation homes for rent by owner in Wilson, rental properties, and for rent by owner homes in Wilson.
Our site, FRBO.com arranges township and city poop, generally.
Discern and distinguish vacation rental in Burke, Burke North Carolina rental home, and rental homes Burke.
Glimpse, glimpse, and learn Union North Carolina rental apartment, Union North Carolina for rent by owner homes, and short term rentals in Union North Carolina.
Identify, come upon, and identify holiday rentals in Granite Falls United States, Granite Falls rental apartment, and house rentals in Granite Falls United States.
Send stunning, exquisite, enticing, and comely poop sheet regarding vacation rental Rockfish North Carolina and vacation homes for rent by owner Rockfish North Carolina found on our site, FRBO.com.
Join our beach directories, lakefront advertisements, secluded listings, and city listings mailing list for Rockfish home rentals, vacation homes for rent by owner Rockfish North Carolina, and Rockfish rental homes.
Vacated log cabin, secluded flat, and hidden villa are immediate in the not far away principality of Rockfish North Carolina.
Distinguish, find out, and light upon apartment rentals Hobbsville United States, Hobbsville rental apartment, and Hobbsville homes for rent by owner.
Upper Hominy North Carolina rental properties, rental homes Upper Hominy, rent houses, and homes for rent by owner in Upper Hominy North Carolina
You can root the oceanfront lists of marked properties and city listed properties under home rentals Rockfish and rental properties in Rockfish.
|
|
