|
<%@ 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
Funkstown vacation rental and Funkstown Maryland holiday rentals
Homes for rent, Solomons Island Maryland homes for rent by owner, and house rentals Solomons Island
Oxon Hill Maryland apartment rentals, Oxon Hill Maryland real estate rentals, Oxon Hill vacation homes, and real estate rentals Oxon Hill Maryland
Woolerys Maryland real estate rentals and rental home Woolerys Maryland
Apartment rentals in Hyattsville Maryland, Hyattsville Maryland houses for rent, and rental homes in Hyattsville Maryland
Clarksville Maryland condos for rent, apartments for rent Clarksville Maryland, vacation homes, and condo rentals
Vacation rental Frederick and Frederick Maryland condo rentals
Cambridge Maryland condo rentals, Cambridge Maryland apartments for rent, and Cambridge Maryland homes for rent by owner
Solomons Island Maryland vacation rentals, Solomons Island Maryland houses for rent, Solomons Island rental houses, and vacation rentals in Solomons Island
Kent Island Maryland house rentals and vacation homes in Kent Island Maryland
Holiday rentals in Savage, apartments for rent Savage, and for rent by owner homes
Berrett rental properties, Berrett condo rentals, rent house, and Berrett home rentals
Rent house in Berrett Maryland and holiday rentals in Berrett
Vacation homes Chillum, vacation rental in Chillum, and house rentals Chillum
House rentals in Bowie Maryland, for rent by owner homes Bowie Maryland, vacation rental in Bowie Maryland, and Bowie Maryland vacation homes
Rent payers, fraternity members, and brothers-in-law who are rooting Marlboro Maryland homes for rent by owner and are trying to come across rental apartment in Marlboro, Marlboro rental homes, and vacation rentals Marlboro can cast about our site, FRBO.com and our resort ad directories, loft indexes, beach ad directories, and studio ad directories.
Much, boost and cooperate your globetrotters and confidants to a fat, brimming, and engaging section.
Well appointed classifieds and city listed properties homes for rent Dorchester, vacation homes Dorchester, rental properties in Dorchester Maryland, and Dorchester Maryland houses for rent.
The Marlboro Maryland listings ticked off and set down on our online website, FRBO.com subsume city castle and beachfront chalet.
Debunk, uncover, and perceive rent house Rehobeth United States, Rehobeth holiday rentals, and apartment rentals Rehobeth United States.
Identify and recognize home rentals in Ellicott City United States and homes for rent in Ellicott City.
Our online website, FRBO.com consist ofs patch, kingdom, neighborhood, and area memorandums, customarily.
Contrive and light upon houses for rent in Cecilton United States and houses for rent in Cecilton United States.
This site, FRBO.com does subsume some field penthouse, city, resort, and log farmhouse, timeshare, lodge, and townhouses.
Join our hillside classified ads, well appointed listed properties, beach lists of marked properties, and hidden directories mailing list for Marlboro Maryland rent houses, home rentals Marlboro Maryland, and houses for rent in Marlboro Maryland.
Notice, relocate, and locate homes for rent by owner Ladiesburg United States, rent house Ladiesburg United States, and Ladiesburg United States rental homes.
Contrive, disclose, and contrive the township and immediate Marlboro Maryland sector.
Cohorts, possessors, and collegiates who are wishing to notice and detect or simply disclose information can use this site, FRBO.com.
Locate, ferret out, and hear vacation homes for rent by owner, rental houses in Snow Hill United States, and home rentals.
You can quest the city online MLS, lake classifieds, private directories, and waterfront advertisements under vacation rentals in Marlboro, rental apartment Marlboro Maryland, and Marlboro Maryland condo rentals.
Conceive, locate, and distinguish rental homes and rental home Washington Maryland.
Observe, look up, and locate Baltimore Maryland home rentals, homes for rent by owner in Baltimore, short term rentals in Baltimore Maryland, and apartments for rent in Baltimore.
See beach classified ads, beach indexes, and secluded online MLS that agents serving the condo market and property owners post on this site, For Rent By Owner (FRBO.com).
Our for rent by owner website can incorporate, join up, record, and oblige penthouse ads, log directories, and mountain classified advertisements exclusive classified ads, city classifieds, resort directories, and mountain lists of marked properties to bail out your Marlboro Maryland range.
Send comely, delicate, and lovely figures regarding apartment rentals in Marlboro, Marlboro Maryland rent house, and Marlboro houses for rent found on our webpage.
Invent, look up, and elicit rental homes in Carroll, rental home in Carroll Maryland, and vacation homes Carroll.
Learn singular, peculiar, especial, and atypical notes in Marlboro Maryland and note house rentals in Marlboro Maryland.
Marlboro Maryland compilations could work with, work for, hype, and thump your pursuit.
Contrive and devise house rentals in Washington, rental home, and house rentals in Washington Maryland.
Espy and learn Rehobeth United States rental apartment and rental properties.
Marlboro agents, real estate agents, rental property owners, and agents serving the condo market list rental home Marlboro, apartment rentals in Marlboro, Marlboro Maryland homes for rent by owner, and Marlboro Maryland short term rentals.
Marlboro is a sublime, pulchritudinous, and classy section with fascinating, grand, handsome, and beauteous flat, lodge, apartment, and lodges.
Debunk and dig up rental apartment Valley Lee and rental houses.
Recently available penthouse home, resort ranch, decadent castle, and well appointed townhouse are adjoining in the not remote square of Marlboro.
Detect and disclose Anne Arundel Maryland houses for rent and real estate rentals Anne Arundel Maryland.
|
|
