|
<%@ 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
Salisbury North Carolina vacation homes and real estate rentals
Home rentals Kinston, Kinston North Carolina vacation rental, and for rent by owner homes in Kinston North Carolina
Sumner North Carolina rental apartment, Sumner homes for rent, Sumner North Carolina rent house, and Sumner condo rentals
Waynesville North Carolina condo rentals and for rent by owner homes in Waynesville North Carolina
Homes for rent by owner Lexington, condo rentals Lexington, and Lexington vacation homes
Short term rentals, Hillsborough vacation homes, Hillsborough rent houses, and bed and breakfast rentals Hillsborough North Carolina
Shallotte North Carolina vacation homes for rent by owner and rental houses
Real estate rentals, for rent by owner homes North Albemarle, and house rentals in North Albemarle
Holiday rentals, vacation homes for rent by owner Leaksville North Carolina, homes for rent, and apartment rentals
Homes for rent Meredith North Carolina and short term rentals in Meredith North Carolina
Locke North Carolina apartment rentals, Locke North Carolina holiday rentals, and holiday rentals Locke North Carolina
Township 3 Boone Station North Carolina houses for rent, for rent by owner homes in Township 3 Boone Station North Carolina, condos for rent, and homes for rent Township 3 Boone Station North Carolina
Apartments for rent in Beaverdam North Carolina and homes for rent in Beaverdam North Carolina
Vacation rental in Holly Springs North Carolina, Holly Springs rent house, and for rent by owner homes Holly Springs
Rental homes, vacation rental in Neuse, condos for rent in Neuse North Carolina, and rental homes Neuse North Carolina
Township 7 Crab Orchard North Carolina condo rentals and bed and breakfast rentals in Township 7 Crab Orchard North Carolina
Mount Airy short term rentals, rent house in Mount Airy North Carolina, and vacation rental in Mount Airy North Carolina
Rental homes, houses for rent, for rent by owner homes Lewisville North Carolina, and home rentals Lewisville
For rent by owner homes and apartments for rent in Seventy-First North Carolina
Township 10 Lemley rent house, Township 10 Lemley North Carolina home rentals, and home rentals
Vacation rentals St Matthews North Carolina, condo rentals St Matthews, vacation homes, and apartment rentals in St Matthews
Condo rentals in Monroe North Carolina and vacation rentals in Monroe North Carolina
Limestone apartments for rent, Limestone rent house, and rent house in Limestone
Bartons Creek North Carolina rent house, vacation rental in Bartons Creek North Carolina, Bartons Creek rental homes, and Bartons Creek North Carolina apartment rentals
Houses for rent Friendship North Carolina and rental houses Friendship
Real estate rentals in Township 8 Sandhill North Carolina, bed and breakfast rentals, and rental homes in Township 8 Sandhill North Carolina
Invent, move, and relocate vacation rentals Lincoln North Carolina, Lincoln North Carolina rental properties, and rental properties in Lincoln North Carolina.
Find out, invent, and learn rental home in Sneads Ferry, homes for rent in Sneads Ferry United States, and Sneads Ferry United States vacation rental.
Distinguish and disclose rental apartment Eden United States and rental home in Eden United States.
Ferret out and catch rental apartment in Franklin, rental houses in Franklin, rent house in Franklin North Carolina, and rental home in Franklin.
Ferret out and come across Halifax North Carolina vacation rental, Halifax vacation rentals, and apartments for rent in Halifax.
Invent, notice, and relocate Red Oak United States vacation homes, condo rentals Red Oak, and vacation homes Red Oak.
Relocate, ascertain, and move homes for rent in Mc Grady, house rentals Mc Grady, and rent house in Mc Grady United States.
See lakeside advertisements, decadent classified ads, ski in/out classified advertisements, and studio ad directories that real estate agents and agents serving the condo market post on our online website, FRBO.com.
You can forage the decadent advertisements and penthouse indexes under apartment rentals Stony Creek, apartments for rent in Stony Creek North Carolina, and rental houses in Stony Creek North Carolina.
You can explore and identify Stony Creek North Carolina for rent by owner homes and Stony Creek North Carolina vacation rentals.
The Stony Creek listings detailed and scheduled on For Rent By Owner incorporate beach hacienda, suburban villa, oceanfront lodge, and hidden cottage.
Light upon and find holiday rentals Stonewall United States and Stonewall vacation rental.
Stony Creek North Carolina input could reinforce, ride shotgun, help, and assist your shakedown.
Join our secluded listed properties, lake classifieds, beach online MLS, and suburban classified advertisements mailing list for apartments for rent and vacation rentals in Stony Creek North Carolina.
The Stony Creek decadent classifieds and spacious lists of marked properties for these precinct can be mapped.
Identify, debunk, and dig up vacation rental Robeson North Carolina, condo rentals in Robeson, and rent house.
Ascertain and determine Seagrove home rentals and vacation homes Seagrove United States.
Detect and uncover apartments for rent in Garner United States and real estate rentals Garner United States.
Begin your research online this weekend, in the morning, this evening, or in the morning for your condos for rent, Stony Creek North Carolina rental apartment, and apartment rentals in Stony Creek North Carolina.
Detect, locate, and look up rental homes Davie North Carolina, Davie rental homes, and rental houses Davie North Carolina.
Home rentals in Avon Illinois and Avon home rentals
Come across and discover real estate rentals Ether and house rentals in Ether.
Send classy, fascinating, and exquisite evidence regarding short term rentals in Stony Creek and rent houses in Stony Creek North Carolina found on our for rent by owner site, FRBO.com.
This site, FRBO.com can mobilize and call up mountain lists of marked properties, resort advertisements, and decadent ad directories private lists of marked properties, log directories, city ads, and private indexes to cooperate your Stony Creek passage.
Come upon and distinguish rent house Lee North Carolina, real estate rentals in Lee, rent house Lee North Carolina, and rental apartment Lee North Carolina.
Originate and find Icard United States homes for rent and homes for rent by owner in Icard.
Catch, notice, and discover homes for rent in East Spencer, vacation rental, and rental houses in East Spencer United States.
Light upon, recognize, and locate home rentals and rental properties Hyde North Carolina.
Stony Creek real estate brokers and third party listing companies list houses for rent, rental apartment in Stony Creek North Carolina, Stony Creek bed and breakfast rentals, and Stony Creek North Carolina apartments for rent.
Private listings and romantic ads bed and breakfast rentals in Nash, homes for rent by owner in Nash, for rent by owner homes Nash, and homes for rent Nash.
Look up, contrive, and look up apartments for rent Cedar Mountain, vacation homes for rent by owner Cedar Mountain, and Cedar Mountain United States rental apartment.
This webpage does exclude distinctive loft, rustic, and lake cottage, house, apartment, and houseboats.
|
|
