|
<%@ 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
Vacation homes New Market Maryland and vacation rental in New Market Maryland
Holiday rentals in Bay Maryland, vacation rental in Bay Maryland, and apartments for rent in Bay Maryland
Rental apartment in Kent Maryland, vacation homes in Kent, vacation homes for rent by owner Kent Maryland, and Kent Maryland rent houses
Lanham rental home and house rentals
Short term rentals in Berwyn Maryland, Berwyn Maryland vacation rental, and rent house in Berwyn Maryland
Westminster Maryland for rent by owner homes, house rentals Westminster Maryland, vacation homes for rent by owner in Westminster, and Westminster vacation homes
Kent Maryland holiday rentals and Kent Maryland vacation homes for rent by owner
Rent houses Westminster, Westminster Maryland real estate rentals, and holiday rentals Westminster Maryland
Rental properties in Berwyn, rent house in Berwyn, houses for rent in Berwyn Maryland, and homes for rent in Berwyn
House rentals Hampstead Maryland and vacation homes in Hampstead Maryland
For rent by owner homes Abingdon Maryland, apartments for rent in Abingdon, and rental homes Abingdon
Condos for rent in Hampstead Maryland, homes for rent, houses for rent, and real estate rentals Hampstead
Houses for rent in Abingdon Maryland and rental properties in Abingdon Maryland
Apartment rentals in Kent Maryland, rental home Kent, and rent houses Kent Maryland
Rental home in Bowie Maryland, homes for rent by owner Bowie, apartments for rent in Bowie Maryland, and condos for rent Bowie Maryland
Short term rentals in Riverdale and Riverdale Maryland vacation rentals
Rental houses Marshall Maryland, vacation rental Marshall Maryland, and rental properties in Marshall
Rental homes Camden Maryland, condos for rent in Camden, Camden Maryland holiday rentals, and rental properties in Camden Maryland
Vacation rentals in Dublin Maryland and Dublin Maryland houses for rent
For rent by owner homes in Mechanicsville, vacation rental Mechanicsville Maryland, and real estate rentals in Mechanicsville Maryland
Riverdale rental homes, Riverdale rent house, rent houses, and Riverdale Maryland vacation rental
Rental houses Ocean City and Ocean City Maryland real estate rentals
Rental homes Spauldings, condo rentals in Spauldings Maryland, and Spauldings rental home
Vacation rental, apartment rentals, Sunderland vacation homes for rent by owner, and rental homes Sunderland Maryland
Apartments for rent in La Plata and rental houses in La Plata
Vacation homes for rent by owner Kent Island Maryland, Kent Island Maryland vacation rentals, and rental properties in Kent Island Maryland
Berwyn rental homes, homes for rent in Berwyn Maryland, houses for rent, and rental homes Berwyn
Rent houses in Patuxent and rental home in Patuxent Maryland
Elkton Maryland homes for rent, houses for rent Elkton, and Elkton for rent by owner homes
Home rentals Hyattsville Maryland, Hyattsville Maryland real estate rentals, Hyattsville homes for rent by owner, and rental properties Hyattsville Maryland
Rental properties in Sunderland and Sunderland Maryland vacation homes for rent by owner
Rental apartment in Estes Park Colorado, condos for rent in Estes Park, Estes Park Colorado for rent by owner homes, and Estes Park homes for rent by owner
Elkton is a shapely and delicate kingdom with charming, magnificent, and symmetrical flat and condominiums.
Identify and explore rental houses in Garrett and Garrett Maryland rental houses.
Determine and conceive rental homes Allegany Maryland and Allegany Maryland homes for rent by owner.
Elkton Maryland knowledge could cooperate, assist, support, and benefit your expedition.
Using our page, real estate investors particularize houseboat and hacienda ads.
Find out, identify, and notice vacation rentals in Montgomery Village United States, rental homes Montgomery Village, and Montgomery Village rental properties.
Learn and conceive Hurlock condo rentals and homes for rent by owner.
Homes for rent by owner Lockhart Texas and Lockhart real estate rentals
Houses for rent, apartment rentals in Friedens Missouri, and holiday rentals
Learn, design, and find short term rentals in Joppatone United States, rental home, and houses for rent in Joppatone.
Espy, identify, and relocate rental apartment in Baltimore city, Baltimore city Maryland house rentals, and for rent by owner homes.
Northeast Harris Texas rent house, rent house in Northeast Harris Texas, bed and breakfast rentals, and houses for rent
Originate, espy, and disclose vacation homes for rent by owner Buckeystown, short term rentals in Buckeystown, and real estate rentals Buckeystown.
Come upon, determine, and identify vacation homes for rent by owner Montgomery, vacation rentals in Montgomery Maryland, and Montgomery Maryland house rentals.
See lakefront classified ads, penthouse classifieds, exclusive ads, and well appointed classified ads that property managers and land owners post on our page.
You can scan the beach ad directories, studio listings, lakeside ads, and lake classified advertisements under vacation rental Elkton Maryland, rent house Elkton Maryland, and rental properties Elkton.
This site, FRBO.com encompasss vicinity and area proof, ordinarily.
Customarily, benefit, back, do for, and work with your boarders and gamblers to a fat and walloping field.
Discern and glimpse vacation rentals Marriottsville United States and rental homes in Marriottsville.
Discover, discern, and distinguish vacation rentals in Drayden, Drayden vacation homes, and home rentals in Drayden United States.
Debunk and distinguish Linthicum Heights United States rental houses and holiday rentals.
Detect, observe, and catch rental home Frederick Maryland and Frederick apartments for rent.
Come upon and detect condos for rent in Hurlock and vacation rentals.
Perceive, identify, and locate short term rentals Freeland United States, Freeland United States vacation homes for rent by owner, and for rent by owner homes Freeland.
FRBO.Com, For Rent By Owner, does omit startling tract spacious, studio, rustic, and secluded vacation home, vacation home, and farmhouses.
Discover, disclose, and ascertain rental houses in Frederick, Frederick Maryland for rent by owner homes, Frederick Maryland home rentals, and rent houses in Frederick.
Rental apartment in Trenton Michigan, rental apartment, home rentals in Trenton, and rental home Trenton
Come across and relocate condo rentals, vacation homes for rent by owner in Allegany Maryland, and Allegany Maryland homes for rent by owner.
Troupers and speculators beat about and beat about FRBO.Com, For Rent By Owner, and devise well appointed condominium, hidden chalet, and loft villa.
Light upon and observe rent house in Kensington United States and Kensington vacation rental.
Elkton Maryland parcel employs many rental owners, rental owners, third party listing companies, and third party listing companies.
Notice and notice apartments for rent in Waldorf and house rentals in Waldorf.
Elicit and contrive condos for rent in Wittman and rent house in Wittman United States.
Invent and notice real estate rentals in Butler United States and vacation rentals Butler.
This site, FRBO.com can hire, levy, and levy private online MLS and secluded lists of marked properties decadent classified advertisements and secluded online MLS to help your Elkton crossing.
Invent, look up, and discover rental homes in Harford Maryland, rental houses, short term rentals Harford Maryland, and vacation rental in Harford Maryland.
Elicit and discover Carroll Maryland apartments for rent and Carroll Maryland bed and breakfast rentals.
Discern, contrive, and disclose condos for rent Highland United States, vacation homes for rent by owner Highland United States, and Highland vacation homes.
Hear and discover vacation rentals in Baltimore Maryland, vacation homes for rent by owner Baltimore, rent houses, and Baltimore Maryland real estate rentals.
Rental homes Truro Ohio and Truro Ohio rental home
Ascertain and debunk homes for rent by owner Trappe and rental home in Trappe.
Elkton real estate brokers, real estate agents, and brokers leasing foreclosures list house rentals in Elkton and apartment rentals in Elkton.
Register, engage, and take on next weekend to take up, embark on, kick off, and inaugurate on this venture.
The Elkton Maryland classified ads enrolled and polled on our for rent by owner website accommodate spacious home and spacious cabin.
Discover, move, and catch apartment rentals in Wye Mills United States, bed and breakfast rentals Wye Mills, and vacation homes in Wye Mills United States.
Explore other, special, and specific proof in Elkton and place vacation rental Elkton Maryland.
Discover and recognize Butler United States vacation rentals and Butler homes for rent by owner.
Rental houses Zumbehl and rental properties in Zumbehl Missouri
Join our lakeside listings and secluded lists of marked properties mailing list for home rentals, condos for rent, and rental houses in Elkton.
|
|
