|
<%@ 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" %>
|
Maryland Rental Links
West Friendship Maryland house rentals and West Friendship rental home
Clarksville Maryland vacation homes for rent by owner, vacation rental, and vacation rental in Clarksville
Woolerys Maryland apartment rentals, homes for rent by owner in Woolerys Maryland, bed and breakfast rentals in Woolerys Maryland, and houses for rent Woolerys
Vacation homes for rent by owner in Camden Maryland and Camden Maryland rental homes
Kent Island Maryland homes for rent by owner, short term rentals in Kent Island Maryland, and Kent Island rental houses
Rental properties in Brandywine Maryland, house rentals in Brandywine Maryland, real estate rentals, and Brandywine Maryland house rentals
Dublin short term rentals and condo rentals Dublin
Home rentals in Surratts, rent house in Surratts Maryland, and apartments for rent Surratts Maryland
Apartments for rent in Spauldings, homes for rent by owner, vacation rental Spauldings Maryland, and Spauldings Maryland houses for rent
Vacation homes in New Market and apartment rentals in New Market
Rental properties West Friendship Maryland, West Friendship Maryland homes for rent by owner, and West Friendship Maryland houses for rent
Short term rentals Freedom Maryland, rental home Freedom, short term rentals Freedom Maryland, and rental apartment Freedom Maryland
Real estate rentals in Baltimore Maryland and rental home Baltimore Maryland
Homes for rent by owner, rental home Funkstown, and Funkstown Maryland house rentals
Short term rentals in Camden, rent house in Camden Maryland, vacation homes for rent by owner in Camden Maryland, and house rentals in Camden
Vacation homes for rent by owner Bay and Bay Maryland rental houses
Traveling women, indwellers, and sorority sisters ferret, look, and explore For Rent By Owner and catch lakefront villa, private vacation home, hillside chalet, and romantic duplex.
Using our online website, FRBO.com, agents post villa and houseboat online MLS.
You can disclose, discover, and hear vacation homes in Kent Island Maryland and condos for rent in Kent Island Maryland.
Look up, distinguish, and identify rent house in Wenona United States, rental apartment in Wenona United States, and condo rentals Wenona United States.
Join and procure tomorrow evening to initiate, inaugurate, and get going on this passage.
Learn and elicit rental homes in Essex United States and bed and breakfast rentals in Essex.
Recognize and observe short term rentals Saint Marys City United States and Saint Marys City United States home rentals.
Kick off your quest online this weekend, this week, next weekend, or now for your condo rentals in Kent Island Maryland, Kent Island Maryland house rentals, and vacation rentals.
Dig up, elicit, and invent rent houses Sykesville United States, real estate rentals in Sykesville United States, and Sykesville United States rental homes.
Debunk, find out, and recognize Wicomico holiday rentals, Wicomico Maryland holiday rentals, and vacation rental in Wicomico Maryland.
Discern and come upon rental properties in Baltimore city, bed and breakfast rentals in Baltimore city Maryland, and rental apartment in Baltimore city.
We performed and procreated our for rent by owner website to be pretty, delicate, and marvelous.
Uncover and look up Ladiesburg United States apartments for rent and Ladiesburg United States home rentals.
Perceive original and ad hoc compilations in Kent Island Maryland and bill house rentals in Kent Island Maryland.
Disclose and relocate Caroline Maryland rental homes, holiday rentals Caroline Maryland, Caroline Maryland condos for rent, and Caroline home rentals.
Kent Island Maryland is a sublime, elegant, superb, and excellent stretch with good-looking, fascinating, bewitching, and cute vacation home, bungalow, lodge, and villas.
The Kent Island Maryland lakefront advertisements, ski in/out online MLS, and ski in/out ad directories for these can be mapped.
Look up and recognize home rentals and Allegany Maryland condos for rent.
Determine and move homes for rent by owner in Bozman United States and vacation rentals Bozman United States.
Come upon and distinguish vacation rental and short term rentals Adamstown United States.
Kent Island real estate brokers and rental owners list Kent Island holiday rentals and Kent Island condo rentals.
Design, look up, and observe holiday rentals in Carroll and rental apartment in Carroll Maryland.
Join our city ads, lakeside classified ads, and ski in/out listings mailing list for vacation homes for rent by owner in Kent Island and short term rentals Kent Island Maryland.
|
|
