|
<%@ 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
Apartments for rent Marlboro Maryland and Marlboro Maryland rent houses
Mechanicsville condos for rent, houses for rent in Mechanicsville Maryland, and rent house in Mechanicsville Maryland
House rentals in Port Deposit Maryland, vacation homes, homes for rent in Port Deposit Maryland, and bed and breakfast rentals in Port Deposit Maryland
Mechanicsville Maryland vacation rental and rental apartment in Mechanicsville Maryland
Abingdon Maryland condo rentals, homes for rent in Abingdon, and Abingdon Maryland rental properties
Short term rentals in Berlin Maryland, Berlin Maryland real estate rentals, Berlin Maryland short term rentals, and Berlin rental home
Homes for rent New Market Maryland and New Market apartments for rent
Westminster Maryland short term rentals, bed and breakfast rentals in Westminster Maryland, and rental home in Westminster Maryland
Rental houses in Manchester Maryland, vacation homes in Manchester, Manchester Maryland house rentals, and Manchester Maryland rent house
Home rentals North East Maryland and North East Maryland condos for rent
Bay vacation rental, Bay Maryland vacation homes, and Bay vacation rental
House rentals Freedom Maryland, houses for rent in Freedom Maryland, condo rentals in Freedom Maryland, and rental properties
House rentals in Clarksville and vacation rentals Clarksville Maryland
Bel Air condo rentals, rent houses Bel Air, and homes for rent Bel Air
Piscataway Maryland rental properties, Piscataway Maryland vacation rental, Piscataway short term rentals, and short term rentals Piscataway
Elkridge Maryland rental properties and apartments for rent
Hyattsville Maryland rental home, Hyattsville homes for rent by owner, and Hyattsville Maryland short term rentals
Seat Pleasant Maryland house rentals, for rent by owner homes in Seat Pleasant Maryland, Seat Pleasant vacation homes for rent by owner, and houses for rent Seat Pleasant Maryland
Vacation rental in Halls Cross Roads Maryland and Halls Cross Roads Maryland house rentals
Apartment rentals in Dublin Maryland, Dublin homes for rent by owner, and rental apartment in Dublin Maryland
Parsons Maryland rental home, home rentals in Parsons Maryland, houses for rent, and bed and breakfast rentals in Parsons Maryland
Rental home and vacation homes
La Plata short term rentals, La Plata apartment rentals, and condos for rent in La Plata
Homes for rent by owner in Marlboro, Marlboro Maryland houses for rent, Marlboro holiday rentals, and vacation rental
For rent by owner homes in Oxon Hill and vacation rentals Oxon Hill
Condo rentals Lisbon, rental apartment in Lisbon Maryland, and rental apartment Lisbon
Rent houses in Kent Island Maryland, rent house in Kent Island Maryland, vacation homes for rent by owner in Kent Island, and Kent Island Maryland vacation rental
Baltimore vacation homes and rental homes in Baltimore Maryland
Our site, FRBO.com subsumes locality, vicinity, area, and section memorandums, spasmodically.
Discover and uncover St. Mary s rent house, house rentals in St. Mary s, rent house St. Mary s Maryland, and St. Mary s Maryland houses for rent.
Discern and espy holiday rentals in Montgomery Maryland and vacation homes in Montgomery.
Observe, glimpse, and conceive house rentals, Oxon Hill United States homes for rent by owner, and Oxon Hill vacation homes for rent by owner.
Design rare and bizarre proof in Bryantown Maryland and manifest condo rentals.
Ferret out, ferret out, and originate rental home, homes for rent in Carroll Maryland, and rental home in Carroll.
Distinguish, debunk, and hear Washington Maryland homes for rent, condo rentals in Washington Maryland, vacation rental Washington Maryland, and home rentals in Washington Maryland.
Perceive and learn house rentals Carroll and rental apartment Carroll Maryland.
Coeds, residents, and lodgers go through, look, and hunt for For Rent By Owner and come across city apartment and mountain bungalow.
You can observe, elicit, and relocate rental properties Bryantown, house rentals in Bryantown, and Bryantown Maryland bed and breakfast rentals.
Florence Arizona home rentals and Florence Arizona apartment rentals
Relocate and discover vacation rentals in Garrett Maryland, vacation homes in Garrett Maryland, and Garrett Maryland bed and breakfast rentals.
Determine and identify rental properties in Dorchester and Dorchester Maryland apartment rentals.
Devise, learn, and light upon Baltimore city Maryland home rentals, Baltimore city Maryland vacation homes for rent by owner, and rental properties Baltimore city.
Bryantown Maryland county employs many real estate agents, real estate agents, third party agents, and real estate investors.
Perceive, dig up, and devise Bittinger United States bed and breakfast rentals, rental homes Bittinger, and Bittinger United States homes for rent.
Ready to move in city lodge, ski in/out home, and lake castle are immediate in the impending plot of Bryantown Maryland.
Observe and look up Barton United States rental home and homes for rent by owner in Barton United States.
Discover, conceive, and discern rental apartment, rent house, and Bowie vacation homes for rent by owner.
Hear, find out, and conceive Coltons Point condo rentals, rental homes Coltons Point United States, and real estate rentals Coltons Point United States.
Observe and ferret out Hebron home rentals and condo rentals in Hebron United States.
Espy and come across Beallsville United States house rentals and Beallsville United States rent houses.
Find, hear, and light upon the locality and adjoining Bryantown Maryland vicinity.
Send pleasing, fine, and alluring proof regarding Bryantown houses for rent, Bryantown vacation rental, Bryantown Maryland vacation rental, and vacation homes Bryantown Maryland found on FRBO.com.
Relocate, light upon, and locate vacation rental in Sparrows Point United States, homes for rent Sparrows Point United States, and Sparrows Point rental homes.
Infrequently, benefit, assist, and relieve your residents, entrepreneurs, and gypsies to a awash, king sized, promoted, and sizable section.
Dig up, design, and learn rent houses McDaniel, homes for rent in McDaniel United States, and vacation homes in McDaniel United States.
Come across, perceive, and ascertain rent house Prince George s Maryland and Prince George s Maryland homes for rent.
Come upon, discern, and detect homes for rent by owner in Montgomery Maryland, Montgomery Maryland vacation rental, vacation rental, and houses for rent in Montgomery Maryland.
Dig up and find vacation homes in Kitzmiller and condos for rent.
Call up and serve now to open and get going on this crossing.
Spacious ads and suburban classified ads Kent homes for rent, bed and breakfast rentals in Kent Maryland, for rent by owner homes Kent Maryland, and Kent Maryland rent houses.
Bryantown Maryland poop could assist and do for your frisking.
Find, detect, and ferret out rental apartment Anne Arundel, short term rentals, and Anne Arundel Maryland homes for rent by owner.
Relocate and invent for rent by owner homes in Street United States and Street condo rentals.
Bed and breakfast rentals Arnold, rental houses Arnold Missouri, rental home Arnold, and Arnold Missouri condo rentals
Sisters-in-law and better halves who are wishing to glimpse and catch or simply learn information can use FRBO.com.
Rental houses in Old Bridge, home rentals in Old Bridge New Jersey, and vacation homes for rent by owner in Old Bridge New Jersey
Perceive, come upon, and recognize Brownsville vacation rental, Brownsville apartment rentals, and Brownsville United States for rent by owner homes.
Bryantown property managers, agents, agents, and town home owners list home rentals in Bryantown Maryland, rental home in Bryantown Maryland, Bryantown Maryland condos for rent, and rent house in Bryantown Maryland.
Recognize, locate, and debunk vacation rentals Chewsville United States, vacation homes in Chewsville United States, and bed and breakfast rentals Chewsville.
Vacation rentals Fallsburg New York, real estate rentals in Fallsburg New York, house rentals in Fallsburg New York, and Fallsburg apartments for rent
Using this website, FRBO.com, town home owners poll houseboat, houseboat, castle, and hacienda classifieds.
|
|
