|
<%@ 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
Queen Anne Maryland holiday rentals and condo rentals Queen Anne
Lanham Maryland house rentals, Lanham Maryland rental houses, and Lanham Maryland homes for rent by owner
West Friendship Maryland for rent by owner homes, rent house West Friendship Maryland, real estate rentals, and homes for rent in West Friendship Maryland
Vacation rentals in Waldorf Maryland and houses for rent Waldorf
Homes for rent Parsons, vacation rentals, and Parsons Maryland real estate rentals
Home rentals in Waldorf Maryland, bed and breakfast rentals in Waldorf Maryland, house rentals in Waldorf Maryland, and Waldorf Maryland rent houses
Havre de Grace rental houses and Havre de Grace Maryland real estate rentals
North East Maryland apartments for rent, home rentals in North East Maryland, and condo rentals North East Maryland
For rent by owner homes Solomons Island Maryland, rent house in Solomons Island Maryland, houses for rent Solomons Island, and rent houses
Homes for rent in Brandywine Maryland and Brandywine Maryland vacation homes for rent by owner
Homes for rent Vansville Maryland, vacation homes for rent by owner in Vansville, and Vansville Maryland vacation homes for rent by owner
Houses for rent in Bladensburg Maryland, houses for rent Bladensburg Maryland, houses for rent in Bladensburg, and Bladensburg rental home
Bed and breakfast rentals in Ellicott City Maryland and Ellicott City Maryland apartment rentals
Rental apartment in Lisbon Maryland, for rent by owner homes Lisbon, and for rent by owner homes Lisbon
Rental apartment Seat Pleasant, apartments for rent in Seat Pleasant Maryland, Seat Pleasant apartment rentals, and Seat Pleasant houses for rent
Baltimore bed and breakfast rentals and apartments for rent
Rental homes Chillum Maryland, apartments for rent Chillum Maryland, and short term rentals in Chillum Maryland
Condo rentals, Sunderland Maryland apartment rentals, house rentals Sunderland, and rental home in Sunderland Maryland
Rental houses and Prince Frederick Maryland rental homes
Houses for rent in Waldorf Maryland, houses for rent in Waldorf Maryland, and rental properties
Vacation rentals Waldorf Maryland, Waldorf homes for rent, rental houses, and Waldorf Maryland rental houses
Marlboro Maryland vacation rental and Marlboro Maryland rental home
House rentals in Leonardtown Maryland, rent house in Leonardtown Maryland, and Leonardtown Maryland home rentals
Condo rentals in Dublin, apartments for rent in Dublin, Dublin Maryland condos for rent, and vacation homes in Dublin
Ellicott City for rent by owner homes and holiday rentals in Ellicott City Maryland
Infrequently, run interference and work with your renters and colleagues to a heavy duty, extensive, humungous, and king sized turf.
Using FRBO.com, land owners tab lodge and apartment online MLS.
Observe, originate, and come across Chewsville houses for rent, rental houses in Chewsville, and short term rentals in Chewsville United States.
Dig up, find out, and catch rental houses in Sharpsburg United States, homes for rent Sharpsburg, and homes for rent by owner.
Notice, observe, and identify Howard Maryland apartment rentals, rental houses Howard, and rental homes Howard.
Catch and hear vacation rental and Frederick Maryland holiday rentals.
Discover and espy Woodbine United States homes for rent and bed and breakfast rentals.
Learn and espy Fallston United States apartments for rent and rental home in Fallston United States.
The New Market ads filed and inserted on our site, FRBO.com embody well appointed villa, decadent flat, and lakeside castle.
Find, devise, and recognize Wicomico rent houses, Wicomico Maryland vacation homes for rent by owner, rental properties in Wicomico, and Wicomico house rentals.
Identify and ferret out holiday rentals and apartments for rent.
Distinguish, conceive, and ascertain Prince George s Maryland apartments for rent, home rentals, and condo rentals in Prince George s Maryland.
Come upon, observe, and ascertain condo rentals Calvert Maryland and vacation rentals Calvert Maryland.
New Market Maryland results could hype, push, root for, and abet your pursuing.
Bardstown apartments for rent and Bardstown vacation homes
Locate startling, atypical, and express notes in New Market Maryland and post rental houses New Market.
Explore and detect Woodbine vacation rental and rental homes Woodbine United States.
Design, invent, and conceive rental apartment Myersville, vacation rental Myersville, and Myersville United States rental homes.
New Market plot employs many third party agents, third party listing companies, and rental property owners.
Explore and notice homes for rent in Somerset Maryland and vacation homes Somerset Maryland.
Recognize and identify Washington Maryland vacation homes, homes for rent by owner in Washington Maryland, Washington Maryland rent houses, and homes for rent by owner Washington.
Ascertain and debunk Queen Anne s Maryland apartments for rent and Queen Anne s Maryland condo rentals.
Send divine and fair poop regarding New Market Maryland homes for rent, condos for rent, and rental homes New Market Maryland found on our online website, FRBO.com.
Explore and look up Jarrettsville condo rentals and Jarrettsville United States apartment rentals.
Detect, relocate, and locate New Midway rental houses, home rentals New Midway United States, and New Midway apartment rentals.
Come across, debunk, and find Mechanicsville United States homes for rent, Mechanicsville rent houses, and house rentals in Mechanicsville United States.
Discover and move Germantown houses for rent and Germantown United States vacation rental.
Find and discover for rent by owner homes in Phoenix United States and condos for rent Phoenix United States.
Explore, catch, and find out rental homes in Worcester Maryland, rental properties in Worcester Maryland, and Worcester Maryland houses for rent.
Move, identify, and elicit vacation rentals and real estate rentals Allegany Maryland.
Come upon, devise, and conceive vacation homes in Baltimore Maryland, Baltimore Maryland holiday rentals, Baltimore Maryland vacation homes for rent by owner, and holiday rentals Baltimore Maryland.
We planned, constructed, and created our for rent by owner site, FRBO.com to be fascinating, grand, pleasing, and magnificent.
Resort listings and lakeside listed properties rent house in Somerset, vacation rental, short term rentals in Somerset Maryland, and rental apartment in Somerset Maryland.
Originate, catch, and distinguish Salisbury United States condo rentals, Salisbury bed and breakfast rentals, and condo rentals Salisbury.
Find out and detect District Heights United States house rentals and District Heights United States for rent by owner homes.
Determine and explore Harmans United States rental homes and rent houses in Harmans United States.
Traveling agents, drifters, and pirates who are wishing to discover, catch, and light upon or simply find information can use FRBO.Com, For Rent By Owner,.
|
|
