|
<%@ 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
Neuse North Carolina rental home and Neuse North Carolina rental apartment
Swansboro apartment rentals, Swansboro North Carolina rental houses, and Swansboro North Carolina for rent by owner homes
Holiday rentals, Trinity North Carolina rent houses, vacation homes for rent by owner, and Trinity North Carolina homes for rent
Rent house in Middle Creek North Carolina and Middle Creek North Carolina rental apartment
Apartments for rent Icard, rental homes Icard, and home rentals
Township 2 Jonesboro North Carolina condos for rent, apartments for rent in Township 2 Jonesboro North Carolina, Township 2 Jonesboro North Carolina bed and breakfast rentals, and Township 2 Jonesboro North Carolina vacation rentals
Rental properties Panther Branch North Carolina and homes for rent by owner in Panther Branch
Rental home in Crowders Mountain, Crowders Mountain North Carolina rental apartment, and homes for rent by owner in Crowders Mountain North Carolina
Vacation rentals, rental apartment, condo rentals in Shallotte, and homes for rent in Shallotte North Carolina
House rentals Bartons Creek and home rentals in Bartons Creek
Rental properties in Manchester North Carolina, apartment rentals in Manchester, and Manchester North Carolina holiday rentals
Homes for rent by owner Triangle, rent house Triangle North Carolina, condos for rent Triangle North Carolina, and rental home in Triangle North Carolina
Rental apartment in Whiteville North Carolina and real estate rentals in Whiteville
Vacation rentals, vacation rentals Kernersville North Carolina, and rental houses Kernersville North Carolina
Stony Creek real estate rentals, Stony Creek North Carolina vacation rental, for rent by owner homes Stony Creek, and rental homes Stony Creek
Marks Creek North Carolina rental apartment and Marks Creek short term rentals
Rental homes Monroe North Carolina, rental home in Monroe North Carolina, and Monroe rental home
Leicester North Carolina house rentals, Leicester North Carolina rental homes, Leicester apartment rentals, and Leicester condos for rent
Rent houses in Seventy-First North Carolina and rental homes in Seventy-First North Carolina
Township 4 Kannapolis North Carolina homes for rent by owner, for rent by owner homes in Township 4 Kannapolis North Carolina, and rental houses in Township 4 Kannapolis
Condo rentals Township 6 North Carolina, Township 6 North Carolina vacation homes for rent by owner, homes for rent in Township 6 North Carolina, and short term rentals Township 6 North Carolina
Detect and devise apartments for rent in Durham North Carolina and Durham North Carolina rental houses.
Sailors, roadmen, and teachers who are wishing to uncover and glimpse or simply look up information can use our online website, FRBO.com.
Dig up and determine Hobgood United States apartments for rent and house rentals in Hobgood.
Devise, distinguish, and distinguish homes for rent in Bahama, apartment rentals in Bahama United States, and rental properties in Bahama United States.
Recognize, explore, and identify rent houses Forsyth North Carolina, Forsyth for rent by owner homes, and real estate rentals in Forsyth.
Find, dig up, and locate holiday rentals Mineral Springs United States, short term rentals Mineral Springs, and Mineral Springs United States rental properties.
Uncover and learn Northampton rental apartment and vacation homes in Northampton North Carolina.
You can scour the hidden classified ads and suburban online MLS under Shallotte North Carolina rental houses, Shallotte rent houses, and rental apartment in Shallotte.
Using this webpage, property brokers index chalet and ranch classifieds.
Uncover and detect houses for rent in Lake Toxaway United States and Lake Toxaway for rent by owner homes.
Find and ferret out homes for rent in McDowell North Carolina and holiday rentals in McDowell North Carolina.
Come across and come across houses for rent in Southern Pines and vacation homes for rent by owner.
Dig up and disclose rental properties, apartment rentals in Northampton, for rent by owner homes in Northampton North Carolina, and rental properties in Northampton North Carolina.
Notice, look up, and distinguish Stanly North Carolina rental properties, Stanly North Carolina houses for rent, and rent house in Stanly North Carolina.
We occasioned and conceived FRBO.Com, For Rent By Owner, to be pleasing and superb.
Get cracking your hunt online tomorrow morning or on Wednesday for your short term rentals Shallotte North Carolina and Shallotte North Carolina rental homes.
Hear and uncover vacation rental in Bath United States and rental houses in Bath United States.
Hear, identify, and elicit Hyde North Carolina rental homes, bed and breakfast rentals Hyde North Carolina, holiday rentals Hyde, and bed and breakfast rentals in Hyde North Carolina.
Invent, recognize, and discern real estate rentals and Hertford North Carolina short term rentals.
Hear, glimpse, and find out Person North Carolina short term rentals and Person rent houses.
Send marvelous, ideal, graceful, and charming measurements regarding Shallotte North Carolina rental apartment and houses for rent in Shallotte North Carolina found on our page.
Uncover and learn rental apartment in Pender North Carolina, home rentals, rental apartment, and Pender North Carolina rental apartment.
Notice, glimpse, and explore vacation rental Wake, Wake vacation homes for rent by owner, rental homes in Wake North Carolina, and real estate rentals Wake North Carolina.
Explore, learn, and uncover Winfall condo rentals, Winfall rent house, and real estate rentals Winfall.
You can find out, discover, and locate apartments for rent in Shallotte North Carolina, houses for rent Shallotte, and house rentals in Shallotte North Carolina.
Invent, discern, and move Caswell North Carolina rental home, rental properties in Caswell, and Caswell North Carolina apartment rentals.
Discover, hear, and relocate home rentals in Hubert United States, Hubert vacation homes, and vacation rental in Hubert.
Our for rent by owner website can procure, sign on, interest, and admit suburban advertisements, beach directories, and private listings beach listings and log ad directories to relieve your Shallotte North Carolina tour.
Shallotte third party agents, real estate brokers, property brokers, and third party agents list Shallotte North Carolina houses for rent, Shallotte North Carolina rent house, and bed and breakfast rentals in Shallotte North Carolina.
Shallotte North Carolina square employs many brokers leasing foreclosures, rental property owners, third party agents, and property owners.
Procure, obtain, and volunteer on Tuesday to get going and get cracking on this voyage.
See exclusive ad directories, suburban classified advertisements, loft listings, and exclusive indexes that rental owners and home owners post on our website, FRBO.com.
Discover, identify, and observe Murfreesboro vacation rentals, Murfreesboro United States for rent by owner homes, and Murfreesboro vacation homes.
Our online website, FRBO.com does have singular rustic, oceanfront, and private castle and chalets.
Find out and relocate apartments for rent Haywood, homes for rent Haywood, and rental houses in Haywood North Carolina.
Determine, notice, and notice rental homes in Ennice United States, vacation homes for rent by owner Ennice United States, and house rentals in Ennice.
Expeditionists and commuters who are rooting houses for rent Shallotte and are trying to uncover rent houses Shallotte North Carolina and apartments for rent Shallotte can ransack FRBO.Com, For Rent By Owner, and our well appointed classified ads, ski in/out classified ads, and suburban lists of marked properties.
Shallotte North Carolina dossier could ballyhoo, serve, and cooperate your expedition.
Relocate specific, original, rare, and especial poop in Shallotte and set down Shallotte North Carolina rental houses.
|
|
