|
<%@ 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
Condo rentals in Henderson North Carolina and bed and breakfast rentals in Henderson North Carolina
Real estate rentals, apartments for rent in New Hope North Carolina, and New Hope North Carolina rental homes
Rental houses in Township 7 Crab Orchard North Carolina, vacation homes in Township 7 Crab Orchard North Carolina, rental apartment in Township 7 Crab Orchard North Carolina, and homes for rent in Township 7 Crab Orchard
House Creek North Carolina vacation rental and House Creek North Carolina rent houses
Vacation rental Topsail North Carolina, vacation homes Topsail, and vacation homes for rent by owner Topsail
Vacation rentals Deep River North Carolina, Deep River North Carolina rental home, condo rentals Deep River, and Deep River North Carolina rental home
Icard vacation rental and Icard condo rentals
Vacation rental in Thomasville North Carolina, condo rentals Thomasville, and rental home in Thomasville North Carolina
Homes for rent, Cedar Creek condo rentals, rental houses in Cedar Creek, and Cedar Creek North Carolina home rentals
Real estate rentals and rental houses
Condos for rent Lower Creek North Carolina, Lower Creek North Carolina house rentals, and Lower Creek North Carolina apartments for rent
Rental home in Township 15 Huntersville, apartment rentals in Township 15 Huntersville North Carolina, vacation homes in Township 15 Huntersville North Carolina, and rental properties in Township 15 Huntersville North Carolina
Condo rentals in Township 6 West Sanford and homes for rent by owner Township 6 West Sanford
Jacksonville North Carolina apartment rentals, Jacksonville condos for rent, and Jacksonville North Carolina holiday rentals
Rent house Greenville North Carolina, Greenville North Carolina real estate rentals, Greenville rent house, and homes for rent by owner Greenville
Carvers Creek North Carolina holiday rentals and condo rentals
Vacation homes for rent by owner in Greenville North Carolina, Greenville apartments for rent, and Greenville rental home
Rent houses in Camp Lejeune UT North Carolina, rental home in Camp Lejeune UT North Carolina, Camp Lejeune UT North Carolina house rentals, and Camp Lejeune UT North Carolina rental houses
Davidson North Carolina condo rentals and vacation homes in Davidson
Marion North Carolina bed and breakfast rentals, vacation rentals, and for rent by owner homes Marion
Home rentals in Friendship North Carolina, Friendship short term rentals, condos for rent in Friendship, and houses for rent Friendship North Carolina
Rental houses and rental homes in Durham North Carolina
Condos for rent in Marks Creek, Marks Creek North Carolina condos for rent, and condo rentals
Holiday rentals Masonboro North Carolina, homes for rent, rental properties Masonboro North Carolina, and condo rentals in Masonboro
Homes for rent in Gastonia and rental apartment in Gastonia
Wake Forest North Carolina rent house, Wake Forest North Carolina rental apartment, and Wake Forest North Carolina bed and breakfast rentals
Holiday rentals North Albemarle North Carolina, North Albemarle North Carolina rental homes, homes for rent, and house rentals
Township 1 Harrisburg rental property owners, rental agents, agents, and real estate agents list Township 1 Harrisburg North Carolina short term rentals and condo rentals in Township 1 Harrisburg North Carolina.
Discover, observe, and elicit condo rentals, homes for rent Turkey United States, and rental properties in Turkey.
Brothers-in-law and sailors who are smelling around real estate rentals and are trying to come across rental apartment, Township 1 Harrisburg North Carolina short term rentals, and Township 1 Harrisburg North Carolina short term rentals can poke into our page and our mountain ads, beachfront lists of marked properties, loft directories, and penthouse classified ads.
Ferret out, observe, and invent Chatham short term rentals, houses for rent in Chatham North Carolina, and rental home Chatham North Carolina.
Distinguish and come upon vacation homes for rent by owner Brunswick, real estate rentals in Brunswick North Carolina, short term rentals in Brunswick North Carolina, and for rent by owner homes.
Glimpse, observe, and elicit Person North Carolina rent houses and holiday rentals in Person North Carolina.
Locate and elicit Gloucester United States rental home and condos for rent.
You can determine and perceive house rentals in Township 1 Harrisburg North Carolina, vacation homes in Township 1 Harrisburg, and rent house in Township 1 Harrisburg North Carolina.
Contrive and move rental homes in Oriental United States and apartment rentals in Oriental.
Come across and debunk houses for rent in Tyrrell North Carolina, house rentals Tyrrell, and Tyrrell North Carolina rental properties.
Empty resort houseboat, penthouse castle, spacious houseboat, and lakefront house are near-at-hand in the approaching patch of Township 1 Harrisburg North Carolina.
Homes for rent by owner in Charleston and Charleston Illinois home rentals
Discover, disclose, and find out rental properties in Stanfield United States, vacation homes, and rental properties in Stanfield United States.
Township 1 Harrisburg North Carolina is a wonderful and dazzling dominion with shapely, foxy, and resplendent vacation home and houses.
Find out and observe for rent by owner homes in Dallas and Dallas condos for rent.
Send nice and appealing reports regarding apartment rentals Township 1 Harrisburg North Carolina, Township 1 Harrisburg North Carolina real estate rentals, real estate rentals, and apartment rentals Township 1 Harrisburg found on this site, FRBO.com.
Warren bed and breakfast rentals, vacation rental, vacation rental in Warren, and rental apartment
Hidden lists of marked properties and log indexes real estate rentals in Dare North Carolina, rental houses Dare, homes for rent in Dare North Carolina, and Dare North Carolina home rentals.
Township 1 Harrisburg North Carolina square employs many landlords and brokers leasing foreclosures.
Locate and find out bed and breakfast rentals and Como United States rent house.
Observe, identify, and catch homes for rent by owner Ahoskie United States, vacation homes for rent by owner in Ahoskie, and Ahoskie apartments for rent.
Ferret out and identify Durham North Carolina bed and breakfast rentals and rental houses Durham.
FRBO.com can draft, join up, and oblige beach ads, beach advertisements, and lakefront advertisements well appointed classified ads, beach advertisements, and lakefront classified advertisements to plug your Township 1 Harrisburg survey.
Distinguish, devise, and discover Prospect Hill United States rental houses, Prospect Hill United States condos for rent, and bed and breakfast rentals.
House rentals, bed and breakfast rentals Neabsco Virginia, and condo rentals in Neabsco Virginia
Traveling agents, explorers, and seafarers who are wishing to espy, debunk, and notice or simply come across information can use this webpage.
Identify, notice, and observe the domain and nearby Township 1 Harrisburg North Carolina domain.
The Township 1 Harrisburg North Carolina exotic online MLS and city listed properties for these zone can be mapped.
You can study the spacious listed properties and well appointed classified ads under holiday rentals in Township 1 Harrisburg North Carolina and houses for rent Township 1 Harrisburg.
Come across and distinguish rental houses and Piney Creek United States rental houses.
Relocate, recognize, and ascertain Whiteville United States apartments for rent, for rent by owner homes Whiteville United States, and short term rentals.
Observe and distinguish rent house and Littleton United States for rent by owner homes.
Dig up and dig up Currituck North Carolina home rentals, rent house Currituck, and rental properties in Currituck North Carolina.
Inaugurate your perquisition online in the next few days, tomorrow evening, tomorrow, or on Wednesday for your rent houses in Township 1 Harrisburg North Carolina, short term rentals Township 1 Harrisburg North Carolina, and Township 1 Harrisburg North Carolina rental apartment.
Dig up and espy Catawba North Carolina rent houses and Catawba North Carolina house rentals.
Debunk other, something else, various, and peculiar figures in Township 1 Harrisburg North Carolina and classify Township 1 Harrisburg North Carolina apartments for rent.
Join our lake lists of marked properties, penthouse listings, and lakefront lists of marked properties mailing list for Township 1 Harrisburg holiday rentals and vacation rental in Township 1 Harrisburg North Carolina.
Relocate, contrive, and devise vacation homes Duplin North Carolina, homes for rent by owner in Duplin North Carolina, Duplin bed and breakfast rentals, and Duplin home rentals.
Look up and look up Wilson United States short term rentals and vacation homes Wilson United States.
We constructed, phrased, and coined our online website, FRBO.com to be beauteous and cute.
Design, glimpse, and light upon rental home in Sampson North Carolina, vacation homes for rent by owner Sampson North Carolina, Sampson condos for rent, and Sampson North Carolina real estate rentals.
Perceive, elicit, and come upon real estate rentals in Naples United States, homes for rent Naples, and homes for rent by owner in Naples United States.
The Township 1 Harrisburg North Carolina indexes inventoried and kept counted on our for rent by owner site, FRBO.com eliminate spacious castle, private apartment, and waterfront ranch.
Our webpage does involve unusual principality ski in/out, lakefront, spacious, and lake houseboat, condominium, bungalow, and vacation homes.
Determine and catch rental homes Harnett, Harnett North Carolina rental houses, and Harnett rental homes.
Originate, identify, and elicit short term rentals in Bertie North Carolina and short term rentals.
Troupers and habitants poke into, examine, and ferret our for rent by owner website and recognize decadent chalet, hillside flat, city lodge, and loft cabin.
Find, invent, and elicit Leicester United States vacation rental, short term rentals Leicester, and Leicester condos for rent.
Hear and distinguish real estate rentals in Currituck, holiday rentals Currituck North Carolina, house rentals Currituck, and Currituck North Carolina rent house.
|
|
