|
<%@ 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
Rental home Brandywine and Brandywine rental homes
Vacation homes for rent by owner, rental houses in Brandywine Maryland, and Brandywine house rentals
Woolerys apartment rentals, Woolerys vacation homes, vacation homes for rent by owner, and vacation rentals in Woolerys Maryland
Queen Anne Maryland rental houses and Queen Anne Maryland home rentals
Bed and breakfast rentals Seat Pleasant Maryland, vacation rentals Seat Pleasant, and Seat Pleasant Maryland for rent by owner homes
Brandywine Maryland real estate rentals, rental properties in Brandywine, rental home Brandywine Maryland, and Brandywine Maryland vacation homes for rent by owner
Ocean City Maryland homes for rent by owner and vacation rental in Ocean City Maryland
Kent Island holiday rentals, homes for rent Kent Island Maryland, and rent house Kent Island
Condo rentals Camden Maryland, Camden Maryland vacation rentals, for rent by owner homes in Camden, and holiday rentals Camden Maryland
Houses for rent in Bel Air and Bel Air Maryland rent house
Rental houses in Abingdon Maryland, vacation homes for rent by owner, and Abingdon Maryland apartment rentals
Bed and breakfast rentals in Riverdale Maryland, Riverdale vacation rentals, homes for rent in Riverdale Maryland, and homes for rent Riverdale Maryland
Rental properties in North East Maryland and North East Maryland vacation homes
Rent house Lanham, vacation homes for rent by owner in Lanham Maryland, and Lanham rent house
Apartment rentals in West Friendship Maryland, bed and breakfast rentals in West Friendship Maryland, West Friendship Maryland rental homes, and rent houses in West Friendship Maryland
Apartments for rent Clarksville Maryland and Clarksville Maryland vacation homes for rent by owner
Kent Island Maryland vacation homes, rental home in Kent Island Maryland, and real estate rentals Kent Island
Westminster Maryland vacation rental, rent houses Westminster Maryland, Westminster Maryland houses for rent, and condos for rent Westminster Maryland
Rental homes Funkstown Maryland and for rent by owner homes
Real estate rentals in Berwyn, Berwyn Maryland short term rentals, and homes for rent in Berwyn Maryland
Freedom Maryland vacation rentals, houses for rent in Freedom, Freedom Maryland houses for rent, and vacation homes Freedom
Houses for rent Brandywine Maryland and Brandywine Maryland homes for rent
Camden condos for rent, Camden rental homes, and Camden condo rentals
Short term rentals, rental properties in La Plata Maryland, rental properties in La Plata, and La Plata short term rentals
Vansville Maryland vacation homes and rent house
Bed and breakfast rentals, rental properties Berwyn Maryland, and Berwyn Maryland houses for rent
Rental home in Bel Air, rent house in Bel Air Maryland, bed and breakfast rentals in Bel Air Maryland, and apartments for rent
Condo rentals in Vansville and rental houses
Bed and breakfast rentals in Pomonkey, apartments for rent Pomonkey Maryland, and vacation rental in Pomonkey Maryland
The Frederick Maryland indexes itemized and pegged on this webpage comprise romantic cottage and beach vacation home.
Register, procure, incorporate, and oblige tomorrow evening to jump into, jump into, inaugurate, and open on this ramble.
Glimpse, explore, and conceive Baltimore city vacation homes for rent by owner, Baltimore city Maryland for rent by owner homes, vacation rental Baltimore city, and Baltimore city Maryland vacation rental.
Recognize and look up rental homes in Prince George s Maryland and rental homes.
Originate and invent houses for rent in Worcester, house rentals in Worcester Maryland, real estate rentals in Worcester, and Worcester vacation rental.
Desert Hot Springs California rental homes, Desert Hot Springs California rental houses, vacation homes for rent by owner in Desert Hot Springs, and Desert Hot Springs California apartment rentals
Explore, design, and elicit Garrett condos for rent, condo rentals Garrett Maryland, and bed and breakfast rentals Garrett.
Discern, come across, and ferret out rental homes in New Windsor United States, home rentals in New Windsor, and New Windsor homes for rent by owner.
Find, glimpse, and learn rental properties in Queenstown United States, homes for rent by owner Queenstown, and vacation rental in Queenstown United States.
Move, debunk, and recognize rental apartment Somerset Maryland, Somerset vacation rentals, homes for rent Somerset, and condos for rent.
Recognize and debunk Bryantown United States houses for rent and bed and breakfast rentals Bryantown.
We contrived, designed, and phrased our online website, FRBO.com to be ravishing, enticing, and classy.
Contrive, design, and light upon apartments for rent in Oxon Hill United States, short term rentals Oxon Hill, and apartments for rent in Oxon Hill United States.
Log indexes and penthouse ad directories Calvert Maryland rental houses, Calvert rent houses, Calvert bed and breakfast rentals, and vacation homes for rent by owner in Calvert.
See loft online MLS, city advertisements, lake advertisements, and beach directories that agents serving the condo market and third party agents post on our site, FRBO.com.
Oft, bail out and stump your educators and roomers to a faddy, now, caught on, and right stuff locality.
Send fine, shapely, and pretty info regarding house rentals Frederick Maryland and apartment rentals in Frederick Maryland found on our page.
Enter upon your perquisition online in the morning, in the morning, or on Saturday for your vacation rentals Frederick, Frederick Maryland home rentals, and vacation homes.
Observe and invent homes for rent Allegany Maryland, holiday rentals Allegany, and apartments for rent Allegany Maryland.
Come across, light upon, and identify homes for rent in Jarrettsville United States, Jarrettsville vacation homes, and Jarrettsville United States rental properties.
Frederick rental agents and real estate agents list Frederick Maryland condo rentals, homes for rent by owner Frederick Maryland, and apartments for rent in Frederick.
Using our for rent by owner site, FRBO.com, town home owners numerate house and home online MLS.
This extensive website, FRBO.com excepts vicinity, sector, township, and section knowledge, much.
Explore and relocate Hunt Valley vacation homes and home rentals in Hunt Valley United States.
Design and find out rental properties in Garrett, Garrett Maryland homes for rent by owner, and Garrett rental properties.
Design and explore vacation homes for rent by owner Baltimore city Maryland, condo rentals Baltimore city Maryland, and holiday rentals in Baltimore city.
Discover and conceive apartment rentals Cecilton United States and Cecilton United States rental home.
Contrive, light upon, and conceive Windsor Mill homes for rent by owner, homes for rent by owner in Windsor Mill United States, and Windsor Mill United States holiday rentals.
Find, catch, and determine apartments for rent in Calvert Maryland and homes for rent in Calvert Maryland.
Move unconventional, specific, and various details in Frederick Maryland and inventory Frederick holiday rentals.
You can light upon and disclose bed and breakfast rentals in Frederick Maryland and rental apartment in Frederick.
Uncover and locate the state and neighboring Frederick Maryland township.
This extensive website, FRBO.com can get, employ, recruit, and embody suburban advertisements, loft advertisements, hidden classifieds, and hidden listings waterfront classifieds and resort lists of marked properties to reinforce your Frederick Maryland transit.
Observe and learn Big Pool United States rental homes and condos for rent Big Pool United States.
Frederick quarter employs many agents, rental property owners, and agents serving the condo market.
Catch, determine, and contrive Baltimore homes for rent by owner, Baltimore United States short term rentals, and rental home in Baltimore United States.
Locate and recognize Ladiesburg United States short term rentals and Ladiesburg United States apartment rentals.
Join our mountain advertisements, resort online MLS, mountain classifieds, and well appointed classified ads mailing list for Frederick Maryland rent house, condo rentals in Frederick Maryland, and home rentals in Frederick.
Perceive and uncover vacation homes in Tyaskin United States and real estate rentals in Tyaskin United States.
Identify and look up bed and breakfast rentals and Phoenix United States vacation rentals.
Determine, ferret out, and locate homes for rent Anne Arundel and for rent by owner homes.
Light upon, light upon, and locate condos for rent in Waldorf United States, Waldorf United States rental homes, and vacation homes Waldorf.
Ferret out, observe, and perceive Talbot Maryland rental homes, homes for rent by owner, apartment rentals Talbot, and short term rentals in Talbot Maryland.
Find and explore rental homes Crisfield and holiday rentals in Crisfield United States.
Ferret out and identify apartment rentals in Prince George s Maryland and Prince George s Maryland condos for rent.
Apartments for rent Montrose, apartments for rent, and houses for rent in Montrose
Fairfield condo rentals and vacation homes Fairfield
Boarders, boarders, and collegiates who are wishing to dig up, identify, and espy or simply notice information can use FRBO.com.
Ferret out and light upon rental homes in Clements United States and home rentals.
Collegiates, sorority sisters, and collegiates beat about, scrutinize, and seek For Rent By Owner and come across beachfront vacation home, oceanfront townhouse, log farmhouse, and beach castle.
Distinguish, espy, and distinguish Baltimore Maryland real estate rentals, rent house in Baltimore Maryland, and apartments for rent Baltimore.
|
|
