Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T06:17:23.840' ,`MLSNumber` = '26793484' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.128510' ,`Longitude` = '-95.076031' ,`PhotoCount` = '49' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '1579500.00' ,`Status` = 'Active' ,`StreetName` = 'Bayview' ,`StreetNumber` = '23526' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Reserve at Bay Harbor, a gated community nestled on the northwest side of Bay Harbor, offers very few home ownership opportunities until now. This 4 bedroom, 4.5 bathroom, bayfront home is oriented on over a ½ acre lot offering nothing but unobstructed Bay Views and Famous Galveston Sunsets. Concrete bulkhead with a long fishing pier leads to a boat & jet ski lift covered by a deck that is perfect for cocktail hour while enjoying the sunset. The interior has as much of a \"wow\" factor as the exterior. Complete with the primary bedroom on the 1st floor, cathedral ceiling, open floorplan, stained pine floors, plantation shutters, stainless appliances, fireplace, cargo lift, newer fencing and a wall of windows offering bay views. Room for a pool, check out the video! It has never been a rental, but could easily be one. Conveys furnished. The boat is available to purchase separately. Don\'t miss seeing this home, it is quite the piece of paradise.' ,`Acres` = '0.5227' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 4 THE RESERVE AT BAY HARBOR (2' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '22767' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'The Reserve At Bay Harbor' ,`TaxAmount` = '18962' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439440' WHERE `Matrix_Unique_ID` = '209844185' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T05:15:38.170' ,`MLSNumber` = '8457017' ,`ListAgentFullName` = 'Jill Tullos' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = 'Kayla Riddle' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.202579' ,`Longitude` = '-95.742812' ,`PhotoCount` = '26' ,`PostalCode` = '77355' ,`RoomCount` = '7' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pine' ,`StreetNumber` = '31918' ,`StreetSuffix` = 'Crossing' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is ready for first time home buyers who want to make it their own, or an investor looking to make cosmetic updates. Wonderful property that has a lot of potential! Open floor plan that lends itself to all kinds of entertainment options. This kitchen has great natural light pouring in thanks to the sky light above. Kitchen has been updated with new cabinets, stainless steel appliances and granite countertops. The wood burning fireplace adds a nice touch to the living spaces. The spacious primary bedroom features a walk in closet and ensuite. Three additional bedrooms and a full bath complete this home. A covered patio and small fenced in area off of the living room is the perfect spot to watch the kids or pets run free. Home sits on a little over 1/2 acre. Refrigerator, washer and dryer are included. Zoned to Magnolia ISD. LOW TAXES AND NO MUD!!' ,`Acres` = '0.56' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MAGNOLIA CROSSING, LOT 17, ACRES 0.560' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '24394' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Crossing' ,`TaxAmount` = '2961' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439441' WHERE `Matrix_Unique_ID` = '211736384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T06:22:11.730' ,`MLSNumber` = '37514159' ,`ListAgentFullName` = 'Jan Saunders' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548944' ,`Longitude` = '-95.763588' ,`PhotoCount` = '32' ,`PostalCode` = '77471' ,`RoomCount` = '9' ,`ListPrice` = '352900.00' ,`Status` = 'Active' ,`StreetName` = 'Fisher Bend' ,`StreetNumber` = '6402' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2391' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely Chesmar home in a wonderful neighborhood situated in a highly developed area with every amenity needed nearby. This home has been well maintained by the original owner. Upgrades include wood floors through main living areas, granite counters, tile in kitchen and wet areas and three car garage. Owner has added a large patio for outdoor enjoyment. Dining room is currently being used as home office and the upstairs game room can easily be used as a fourth bedroom if needed. There are two full baths downstairs and a full bath upstairs. Easy to show and owner is flexible on closing date. Beautiful community park and pool nearby and very easy access to Highway 59. Brazos Town Center is a charming shopping area with lots of restaurants. A fantastic place to call home.' ,`Acres` = '0.2047' ,`Area` = '30' ,`BuilderName` = 'Chesmar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE RESERVE AT BRAZOS TOWN CENTER SEC 1, BLOCK 4, LOT 43' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8916' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Reserve At Brazos Town Center' ,`TaxAmount` = '7132' ,`TaxRate` = '2.7148' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439441' WHERE `Matrix_Unique_ID` = '212139045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T06:57:38.760' ,`MLSNumber` = '64195129' ,`ListAgentFullName` = 'Dwight Vincent' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.009960' ,`Longitude` = '-95.151520' ,`PhotoCount` = '17' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Legend Oak' ,`StreetNumber` = '20027' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2382' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASSET LIQUIDATION SALE - $30K+ BELOW MARKET VALUE - SOLD AS IS- JUST NEEDS A LIL\' TLC AND YOUR PERSONAL TOUCH TO MAKE THIS YOUR DREAM HOME - GREAT BONES - HUGE CORNER LOT BACKS UP TO THE GOLF COURSE / NO BACK NEIGHBORS- RECENT VINYL PLANK WOODFLOORS - HUGE MASTER BATH RECENTLY REMODELED - DUAL VANATIES- WET BAR- BRICK FIREPLACE- 22 KW GENERAC GENERATOR- 3 CAR GARAGE- CIRCLE DRIVE WAY- 5 MINUTES FROM THE LAKE - 15 MINUTES TO IAH- AND SO MUCH MORE.... INVESTORS & BARGAIN HUNTERS WELCOME!!!!... professional pics coming soon after asset liquidation sale /// bring all reasonable offers' ,`Acres` = '0.2583' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 9 PINEHURST OF ATASCOCITA SEC 7' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '695' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Pinehurst Atascocita Sec 07' ,`TaxAmount` = '4316' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439441' WHERE `Matrix_Unique_ID` = '212979641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T06:03:31.293' ,`MLSNumber` = '40689303' ,`ListAgentFullName` = 'Carla Melendez' ,`ListOfficeName` = 'The Yarborough Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858722' ,`Longitude` = '-95.304486' ,`PhotoCount` = '21' ,`PostalCode` = '77016' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Bretton' ,`StreetNumber` = '10121' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1667' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautifully renovated home in Fontaine Place. Renovations include sprayed E-barrier paint insulation in the attic for major protection and energy saving, also new blown insulation, New paint inside and out, New floors in the entire house, New cabinets, New granite in kitchen and baths, New stainless steel appliances, Bathrooms fully remodeled, and new water heater. Spacious fenced backyard ! Schedule your appointment TODAY!' ,`Acres` = '0.157' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 655 BLK 23 FONTAINE PLACE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fontaine Place Sec 05' ,`TaxAmount` = '2884' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439441' WHERE `Matrix_Unique_ID` = '213264610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T06:25:52.870' ,`MLSNumber` = '27854536' ,`ListAgentFullName` = 'Helen Nguyen' ,`ListOfficeName` = 'LV Realty & Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710778' ,`Longitude` = '-95.579401' ,`PhotoCount` = '23' ,`PostalCode` = '77072' ,`RoomCount` = '5' ,`ListPrice` = '234500.00' ,`Status` = 'Active' ,`StreetName` = 'Bugle' ,`StreetNumber` = '4323' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1532' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Updated single story 3/2/2 with wrap around courtyard and big backyard in convenient area. Newly renovated bathrooms, Carpet, Kitchen Cabinets, New Quart kitchen Countertop, Appliances, & Gas Range. Fresh Interior and Exterior Paint. Open Concept. High ceiling in the family room. Fire place. Primary bathroom has skylight ceiling and built-in cabinets, & standing shower. Easy to access to Beltway 8 and 59 S. Won\'t last long!' ,`Acres` = '0.1322' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 BRAYS VILLAGE SEC 2 R/P' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brays Village Sec 2' ,`TaxAmount` = '3673' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439442' WHERE `Matrix_Unique_ID` = '213467083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T06:58:53.480' ,`MLSNumber` = '55141530' ,`ListAgentFullName` = 'Jose Torres' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072764' ,`Longitude` = '-95.407483' ,`PhotoCount` = '25' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Valley Lane' ,`StreetNumber` = '25522' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1927' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home built in 1971 has been fully renovated with modern style accents. Upon entering, you’re greeted with a formal living area that leads into the formal dining. The kitchen features quartz countertops and brand new stainless appliances (refrigerator included). From the kitchen you can enjoy the views of the wood burning fireplace and large brick pillars. You will also find built in book shelves conveniently located in the living area. This beautiful single story home has 4 large bedrooms with the primary bedroom conveniently located towards the back of the home. The primary bathroom features a custom built walk-in shower with dual sink vanity. Roof and A/C replaced June 2022! This home is conveniently located within minutes of the Woodlands, multiple restaurants and major freeways. Ask about our rent to own program. ' ,`Acres` = '0.2101' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 5 LEXINGTON WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods' ,`TaxAmount` = '3373' ,`TaxRate` = '2.2769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439442' WHERE `Matrix_Unique_ID` = '213525086' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T05:39:11.690' ,`MLSNumber` = '79874041' ,`ListAgentFullName` = 'Charlotte Huwar' ,`ListOfficeName` = 'Ross & Marshall Realty' ,`SellingAgentFullName` = 'Melenaite Uata' ,`SellingOfficeName` = 'Aston Rose Sports &' ,`Latitude` = '30.025871' ,`Longitude` = '-95.520850' ,`PhotoCount` = '28' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '255000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Clee' ,`StreetNumber` = '6906' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A centrally located home between Hwy 249 and Grand Parkway (99) and I45. It\'s approximately 6 miles from the Vintage Shopping Center and more shopping on Hwy 249 including Willowbrook Mall. There are several hospitals in the area. This is a well maintained 3 bedroom 2 bathroom home with a attached two car garage. Please verify all room measurments as they are approximate. The kitchen cabinets are all new, countertops, sink, faucets and disposal/plumbing and pod lights were done in 2020. The stove, microwave, dishwasher and refrigerator (that is staying) were put in in 2022. New double pane storm windows were installed in 2020 and have a transferable warranty. This home was completely painted inside and out and is ready for a family to move into. The flooring in the home is italian tile flooring in living room, dining room/kitchen, breakfast area and hallways. The rest of flooring in this home is new waterproof /scratchproof wood laminate flooring. Sits on a cul-de-sac. Come see it.' ,`Acres` = '0.2063' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 53 BLK 4 017*W5720756-000-004-053 WOODBRIAR PLACE' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodbriar Place' ,`TaxAmount` = '4544' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439442' WHERE `Matrix_Unique_ID` = '213525366' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T05:32:20.673' ,`MLSNumber` = '28986210' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919430' ,`Longitude` = '-95.729872' ,`PhotoCount` = '44' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '406000.00' ,`Status` = 'Active' ,`StreetName` = 'Mesquite Flats' ,`StreetNumber` = '18427' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Innovative room placement and sophisticated style combine to create The Beckley luxury home plan. Vibrant space and limitless potential make the open-concept floor plan a decorator’s dream. Create your ideal specialty room for good conversation and great books in the cheerful sunroom. The streamlined kitchen features a presentation island and plenty of room for collaborative feast creation. Your upstairs retreat provides a lively place for a family theater or a fun and games lounge. The lovely spare bedrooms include plenty of living and closet space to support growing minds and personalities. Escape to the spectacular Owner’s Retreat and its deluxe bathroom with enough closet space to expand your wardrobe. Livability enhancements include a downstairs powder room, extra garage storage space, and a breezy side porch. Your Home Team is ready to begin building this impressive new home plan.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41 Block 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1284' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.57' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668439442' WHERE `Matrix_Unique_ID` = '213568256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T06:41:05.817' ,`MLSNumber` = '46013628' ,`ListAgentFullName` = 'Jill Smith' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164599' ,`Longitude` = '-94.924345' ,`PhotoCount` = '22' ,`PostalCode` = '77535' ,`RoomCount` = '8' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2343' ,`StreetNumber` = '490' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors welcome! Find plenty of space and comfort in this lovely 3 bedroom, 2 bathroom home on a 1.19 acre lot in Dayton Oaks, featuring wood flooring, new water heater, large carport with workshop and storage room, formal dining room and a spacious great room with high ceilings. The sprawling outdoor space includes a covered patio, above-ground swimming pool with deck, storage shed, septic tank and water well. Prepare a home-cooked meal in the kitchen complete with a double oven and electric cooktop. The serene master suite boasts a walk-in closet and a shower. Located off State Highway 321 and FM 1008, just a short drive to central Dayton and Cleveland. Explore endless miles of trail and nature parks surrounding the Trinity River including the Trinity River Wildlife Refuge. Zoned to Dayton ISD and easy access to Hwy. 99.' ,`Acres` = '1.187' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DAYTON OAKS, LOT 61, ACRES 1.187' ,`LotDesciption` = 'Cleared' ,`LotSize` = '51706' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dayton Oaks' ,`TaxAmount` = '2386' ,`TaxRate` = '1.7263' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank,Well' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439442' WHERE `Matrix_Unique_ID` = '213584494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T05:33:58.780' ,`MLSNumber` = '77165219' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924055' ,`Longitude` = '-95.732414' ,`PhotoCount` = '23' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '484000.00' ,`Status` = 'Active' ,`StreetName` = 'Prosperous' ,`StreetNumber` = '15107' ,`StreetSuffix` = 'Place' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fulfill your lifestyle dreams with the Modern Farmhouse design of The Allanson in Bridgeland\'s Parkland Row. This chef\'s kitchen offers all the culinary conveniences celebratory feasts, everyday breakfasts, and quick snacks. The sliding glass doors open up to your oversized covered patio with plenty of room to gather in the evening with family and friends. Enjoy relaxing in your private Owner’s Retreat & spa like bathroom.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 5' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668439443' WHERE `Matrix_Unique_ID` = '214008748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T06:59:20.500' ,`MLSNumber` = '73210313' ,`ListAgentFullName` = 'Roman Rodriguez' ,`ListOfficeName` = 'Green Residential' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726950' ,`Longitude` = '-95.502448' ,`PhotoCount` = '41' ,`PostalCode` = '77063' ,`RoomCount` = '9' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Freshmeadows' ,`StreetNumber` = '3515' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Bring your offer! Seller offering $5K to buy down rate with valid offer* Gorgeous 3 bedroom, 2.5 bath property located in Briarwood Subdivision. The property has been updated through most major ticket items. The home has a low age A/C, foundation repair with warranty ($125 to transfer), updated flooring, updated bathroom, and other details that you will love. As you enter the home, you are greeted by a spacious and elegant den that flows into the large formal dining space. Hand-sculpted wood flooring gives a timeless aesthetic. The living room has beautiful vaulted, beamed ceilings, a cozy brick fireplace (gas or wood), and built in shelving. Kitchen has been renovated with 2 toned cabinetry, granite countertops, and gorgeous backsplash. Updated flooring throughout the home. Guest bedroom was converted into second primary bedroom and is attached to the renovated bathroom. The bedroom also has an attached secondary room that has so many possibilities. 3 car detached garage. ' ,`Acres` = '0.2388' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 17 BRIARMEADOW SEC 1 PAR R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '762' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PINEY POINT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarmeadow Sec 1 Pt Rp' ,`TaxAmount` = '9258' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439443' WHERE `Matrix_Unique_ID` = '214190707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T06:52:58.280' ,`MLSNumber` = '6575711' ,`ListAgentFullName` = 'Angie Willis' ,`ListOfficeName` = 'Texas State Realty' ,`SellingAgentFullName` = 'Kevin Ierardi' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.557217' ,`Longitude` = '-95.619987' ,`PhotoCount` = '39' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '199000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hunters Creek' ,`StreetNumber` = '59' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1046' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'re looking for a peaceful and tranquil environment \"look no further\". Charming home located in Gated Wildwood Shores, a protected bird sanctuary. Nestled in the Sam Houston National Forest with views of Lake Conroe from your porch. Amenities: 2 boat launches, dry boat storage area, 2 swimming pools, tennis court, playground, basketball court, marina, fishing, picnic area and covered grill. Home offers vaulted rustic wood beam ceilings, giving an open fill to the kitchen and living. Spacious loft can be used as second bedroom. 18 minutes from the city of Huntsville, 30 minutes from the Woodlands and 60 minutes from Houston. Lake living at its best.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WILDWOOD SHORES (SEC 1), BLOCK 2, LOT 26' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '8051' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '891' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Wildwood Shores' ,`TaxAmount` = '2019' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668439443' WHERE `Matrix_Unique_ID` = '214419258' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214724075','1668439443','214724075','2022-11-14T06:36:35.400','73674738','Elizabeth Manriquez','Keller Williams HoustonCentral','','','30.178661','-95.167975','32','77357','4','469000.00','Active','Whispering Pine','2218','','Roman Forest','3','0','3','2088','Single-Family','**UNDER CONSTRUCTION! PRICING WILL ESCALATE AS HOME NEARS COMPLETION, BUY EARLY SAVE MONEY. Estimated Completion December 31st 2022**\r\nBeautiful new custom built home located in popular Roman Forest TX. Sitting on almost half an acre this 3 bedroom, 3 bath, 3 car garage equipped with electric vehicle charging stations. Office/study room can be used as an additional bedroom. Home features include modern pivot door, tall ceilings, electric fireplace, LED lighting throughout home, Samsung appliances, quartz countertops, custom high cabinets, tile floor throughout the home and carpet in bedrooms. Amazing covered back patio with a large backyard. Roman Forest is off of I-69 and minutes from the Grand Pkwy and Valley Ranch Town Center. Quiet, safe and friendly neighborhood which has a community pool, splash pad, pavilion and park for residents. Deed restrictions, No HOA, No Fees!! Minutes from The Grand Parkway/99 and the amazing new Valley Ranch Town Center. Schedule your appointment today!','0.4591','40','EENN HOMES, LLC','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Mock Fireplace','1','Porter/New Caney East','Central Electric,Central Gas','0','ROMAN FOREST 01, BLOCK 11, LOT 5','Cleared','20000','Appraisal District','','','1','To Be Built/Under Construction','3','Electric Oven','0','','','Gas Cooktop,Gas Range','','Composition','39 - New Caney','DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Builder','1','Contemporary/Modern,Craftsman','Roman Forest 01','959','2.9064','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214725645','1668439443','214725645','2022-11-14T06:39:42.470','11755895','Anthony Silvas','JLA Realty','','','29.698459','-95.279376','25','77017','4','145000.00','Active','Kimble','8021','Street','Houston','2','0','4','1380','Single-Family','','0.1492','3','','','','','Other Disclosures','','','','Hobby Area','Central Electric','0','LT 19 MAYSWOOD','Other','6500','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','SANCHEZ ELEMENTARY SCHOOL (HOUSTON)','CHAVEZ HIGH SCHOOL','DEADY MIDDLE SCHOOL','Request Online Appointment','Appraisal District','1','Traditional','Mayswood','2520','2.3307','Public Sewer,Public Water','1940','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214725662','1668439443','214725662','2022-11-14T06:38:10.917','4487119','Anthony Silvas','JLA Realty','','','29.713153','-95.274952','50','77012','4','125000.00','Active','John','8308','Street','Houston','1','0','4','1910','Single-Family','','0.1148','4','','','','','Other Disclosures','','','','East End Revitalized','No Heating','0','LT 5 BLK C SMITH & GIBBONS','Other','5000','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','HARRIS J R ELEMENTARY SCHOOL','MILBY HIGH SCHOOL','DEADY MIDDLE SCHOOL','Request Online Appointment','Appraisal District','1','Traditional','Smith & Gibbons','2947','2.3307','Public Sewer,Public Water','1940','Appraisal District'); --> New record created successfully