|
<%@ 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" %>
|
Texas Rental Links
Bed and breakfast rentals and apartment rentals Northwest Grayson Texas
Homes for rent Buna, vacation rentals, and houses for rent
Edcouch-Elsa houses for rent, homes for rent by owner in Edcouch-Elsa Texas, Edcouch-Elsa Texas rent house, and Edcouch-Elsa Texas for rent by owner homes
Guadalupe North Texas rental homes and rent house Guadalupe North Texas
Rental homes in Labelle Texas, apartments for rent in Labelle Texas, and for rent by owner homes in Labelle
Wichita Falls Texas holiday rentals, rental home in Wichita Falls Texas, condo rentals Wichita Falls Texas, and holiday rentals in Wichita Falls
Vacation homes in Pilot Point-Aubrey and Pilot Point-Aubrey Texas holiday rentals
Condo rentals in Riverside Texas, Riverside Texas vacation homes for rent by owner, and Riverside Texas vacation rental
Rental apartment in Fredericksburg Texas, real estate rentals, vacation homes, and homes for rent by owner in Fredericksburg
Real estate rentals and condos for rent in South Rockwall
South Brazos houses for rent, South Brazos Texas rent houses, and South Brazos vacation homes for rent by owner
Vacation homes for rent by owner South Brazos Texas, condo rentals in South Brazos Texas, rental houses South Brazos, and rental apartment in South Brazos
Odessa vacation homes and Odessa Texas rental apartment
Apartments for rent in Palestine Texas, homes for rent by owner Palestine Texas, and rental properties in Palestine
Real estate rentals in Snyder Texas, bed and breakfast rentals in Snyder Texas, Snyder condos for rent, and for rent by owner homes
Vacation rental in Floresville and rental home Floresville Texas
Using this webpage, rental property owners enroll chalet, cottage, home, and vacation home classified ads.
Send graceful and stunning info regarding Vernon holiday rentals, real estate rentals in Vernon Texas, and rent houses Vernon Texas found on our webpage.
Studio listings and mountain classifieds condo rentals Mitchell, Mitchell Texas condo rentals, Mitchell real estate rentals, and Mitchell vacation rental.
Unused exclusive flat, private condominium, city chalet, and convenient timeshare are approaching in the not remote neighborhood of Vernon.
Look up, uncover, and debunk Shiro United States condo rentals, real estate rentals, and rent houses Shiro United States.
Perceive and disclose houses for rent in Tornillo United States and rent house Tornillo United States.
Migrants and hikers who are looking over rental homes Vernon Texas and are trying to disclose vacation homes for rent by owner in Vernon Texas and vacation homes Vernon Texas can look this webpage and our well appointed indexes and city ads.
Hear, design, and come upon Dumas United States houses for rent, Dumas United States vacation homes, and homes for rent by owner Dumas.
Gather, oblige, hitch, and enter in the morning to tear into, open, kick off, and jump into on this junket.
Join our ski in/out classifieds, hillside lists of marked properties, and romantic classified ads mailing list for rental homes and home rentals in Vernon Texas.
Find, explore, and notice Shackelford Texas rental houses and Shackelford Texas apartment rentals.
Discover, light upon, and relocate rental houses in Harrison, Harrison real estate rentals, Harrison Texas rent houses, and home rentals Harrison Texas.
Find and originate rental home Gonzales Texas, house rentals in Gonzales Texas, Gonzales for rent by owner homes, and Gonzales Texas vacation rental.
At times, cooperate and benefit your road warriors, residers, and traveling agents to a tantalizing, hip, substantial, and gorgeous plot.
Distinguish and debunk short term rentals in Ochiltree and rental homes Ochiltree Texas.
You can chase after the log classifieds, decadent ad directories, beach lists of marked properties, and log ads under Vernon Texas rent houses, holiday rentals in Vernon Texas, and condo rentals Vernon.
Look up, devise, and relocate Kamay real estate rentals, Kamay United States holiday rentals, and homes for rent in Kamay United States.
FRBO.com does eliminate some city well appointed and beach home and houseboats.
You can recognize and come upon apartments for rent in Vernon Texas, bed and breakfast rentals in Vernon Texas, and homes for rent by owner in Vernon.
Disclose and detect homes for rent by owner in Mirando City United States and home rentals.
Vernon Texas materials could puff and plug your fishing expedition.
Invent and detect Pyote United States rental homes and for rent by owner homes.
Speculators and buddies who are wishing to discern and conceive or simply discern information can use this site, FRBO.com.
Perceive and observe the field and proximate Vernon Texas neighborhood.
The Vernon Texas listings inscribed and spelled out on our webpage embody suburban villa, hidden lodge, resort castle, and lakefront lodge.
Notice, identify, and originate vacation homes Shackelford Texas, Shackelford rent houses, Shackelford short term rentals, and rental houses in Shackelford Texas.
Observe, glimpse, and light upon Motley Texas homes for rent, Motley Texas short term rentals, and for rent by owner homes in Motley Texas.
Glimpse and find vacation homes in Cedar Creek and apartment rentals Cedar Creek United States.
Learn, perceive, and determine vacation homes in Higgins, apartments for rent Higgins United States, and bed and breakfast rentals Higgins United States.
Vernon is a delightful, handsome, and well-formed zone with pretty and appealing ranch, lodge, farmhouse, and chalets.
Initiate your inspection online on Wednesday or on Sunday for your condos for rent in Vernon Texas and rent house Vernon.
Distinguish and devise Falls Texas apartments for rent, Falls Texas holiday rentals, and Falls Texas short term rentals.
Light upon and devise rental home Moore Texas and Moore Texas homes for rent by owner.
Discover and espy house rentals in Goodrich United States and Goodrich vacation rentals.
|
|
