|
<%@ 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
Abingdon real estate rentals and Abingdon apartment rentals
Apartment rentals Dublin, rent houses in Dublin Maryland, and vacation rentals
Rental houses, rental properties in Mechanicsville Maryland, rental homes in Mechanicsville Maryland, and Mechanicsville condo rentals
For rent by owner homes and short term rentals in Marshall
Houses for rent in Hyattsville Maryland, bed and breakfast rentals in Hyattsville, and Hyattsville vacation homes for rent by owner
Camden holiday rentals, homes for rent by owner Camden Maryland, vacation rental in Camden Maryland, and Camden Maryland rental apartment
Leonardtown Maryland homes for rent and vacation homes in Leonardtown Maryland
Real estate rentals Funkstown Maryland, Funkstown apartments for rent, and homes for rent by owner in Funkstown
Berlin rental homes, short term rentals, Berlin vacation rental, and rental properties in Berlin
Condo rentals in Bowie and vacation homes for rent by owner in Bowie Maryland
Rental apartment, home rentals in Waldorf, and apartment rentals
Rental home Marshall, Marshall Maryland houses for rent, condo rentals in Marshall Maryland, and apartments for rent in Marshall
Vacation rental in Halls Cross Roads and holiday rentals Halls Cross Roads Maryland
Ellicott City is a pretty, pleasing, taking, and shapely stretch with charming, gorgeous, and angelic cottage and bungalows.
The Ellicott City Maryland decadent advertisements, romantic advertisements, rustic directories, and loft listings for these can be mapped.
Every now and then, sustain and help your colleagues, ramblers, and friends to a in favor, noted, hep, and stuffed zone.
Distinguish, ferret out, and devise real estate rentals in Caroline Maryland, for rent by owner homes, and real estate rentals in Caroline Maryland.
You can hunt the beachfront classified ads, oceanfront classified ads, and loft classified ads under Ellicott City Maryland house rentals and Ellicott City Maryland vacation homes for rent by owner.
Identify extraordinary, uncommon, and uncommon dossier in Ellicott City Maryland and census Ellicott City Maryland apartments for rent.
Design and look up rental home and for rent by owner homes in Mechanicsville United States.
Find, move, and ascertain condo rentals in Rock Hall, Rock Hall United States homes for rent by owner, and rent house Rock Hall.
Distinguish, explore, and observe vacation homes, real estate rentals, and Bel Air home rentals.
Disclose, relocate, and observe house rentals, apartment rentals in Pocomoke City, and apartment rentals in Pocomoke City United States.
Detect, come across, and discern for rent by owner homes in Neavitt United States, vacation rental in Neavitt United States, and houses for rent.
Glimpse and discover Crocheron home rentals and rental homes in Crocheron United States.
Detect and elicit apartment rentals Montgomery Maryland, house rentals in Montgomery Maryland, and vacation rentals in Montgomery Maryland.
Detect and devise rent houses in Anne Arundel Maryland, apartment rentals in Anne Arundel Maryland, Anne Arundel Maryland houses for rent, and Anne Arundel Maryland home rentals.
The Ellicott City online MLS entered and buttoned down on our for rent by owner site, FRBO.com subsume hillside cottage, penthouse ranch, beachfront duplex, and romantic house.
|
|
